Re: Can't connect to SQL-Server 2000 using the Server Name

Re: Can't connect to SQL-Server 2000 using the Server Name

 

  


Add The Server name to the Host file.

Cheers
Regards
Vijay



On Tue, 14 Oct 2003 Brian A Canaday/HSC/VCU wrote :
>I am trying to connect to a stand alone SQL-Server 2000 box running Win2k3
>with a DSN - - - - on one of my client pcs I can only connect with the
>server IP address and not with the server name. I installed Enterprise
>Manager for this developer and same thing here...only using IP address, I
>have many other clients who can connect with the server name - - - - has
>anyone had this problem?
>
>I have configured the Network lib to listen on TCP/IP and tried Named
>Pipes - - - neither will work on this box - - - any suggestions?
>
>Thanks.
>
>Brian A. Canaday
>Lead Applications Analyst/Programmer
>VCU School of Dentistry
>804.828.2330
>[Email Address Removed]MS Sql Server LazyDBA home page