Client Setup 1

[AllanBowker]

NOVICE

MS SQL Server 2000

How do I setup the client software on a workstation so that I can connect to my DB's?

 

[SQLBill]

What type of client software?

The type might make a difference, but the place to start is with your ODBC connection. On the client workstation, go to START > Settings > Control Panel > Data Sources (ODBC), then go to the SYSTEM DSN tab and add a new connection following the prompts. In most cases, when it asks for the server information (Which SQL Server do you wish to connect to?)...use the IP address for the SQL Server.

Hope this helps...

-SQLBill

 

[tlbroadbent]

If you want to use the SQL Server tools, you can install them from the installation CD or the downloaded setup program. For other client programs such as VB, C++, ASP, etc. you'll need to install the MDAC components. This is also available on the CD, in the SQL Server setup program you may have downloaded or you can download MDAC itself from Microsoft.

http://www.microsoft.com/data/download.htm

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[AllanBowker]

Problem solved by a friend.

I needed to use the IP address in the Alias and not use netbios names.