SQL installed?

[heffrey45]

Hi I have never worked with SQL or many databases but my boss is wanting me to get an access file to talk to a SQL database located on a different machine. I figured out I need an ODBC but I am having trouble setting this connection up.
My question is how would I know if SQL is installed on the machine?
There is an icon in the bottom right corner that when I put my mouse over it it says MSSQL Server and the icon is a little computer with a play button on it.
Does that mean SQL is installed and running? Plus what does the SQL Server Service Manager do?
Thanks. Since I dont know any thing about this stuff, any help you can provide will be greatly appreciated

 

[chakatheapeman]

Yes

Yes hitting play means that you have a SQL server running.

You should have a test server. When you create a project against an existing database access allows you to change not only the data but the structure and objects in the data base itself. Set up a server on your PC copy the database. Develop against that. The OFFICE Pro cd has SQL server on it some where.

After you install your server you will be able to connect to both the test and development SQL servers in the enterprise manager for sql(The client tools).