HOW TO CONNECT TO A DATABASE

[mimi2]

Hello,
There is a database that is on the network. We receive requests to produce reports from the data. There is only one department that has acces for now.

What should i do to have acces too ?
1. find the server name or ip address
2. passwords
3. make a physical connection (how ?)
4. ??????

thanks for any hint.

 

[tlbroadbent]

Who administers the database? That person should be able to answer your questions.

You will need to know

1) SQL Server name or IP address.
2) The authentication methods used - Integrated security or mixed?
3) The database administrator will need to provide logins or if integrated security is used, she will need to grant access to the server and datbase(s) to the Windows logins.
4) The client workstations will need access to the server via a LAN or other connection.
5) Workstations will also need connectivity software such as MDAC.

You should also refer to the SQL Server documentation for more detailed information about accessing SQL Server databases.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.comcast.net/sql/sql_articles.htm