Can not connect.

[woyler]

Hello all. I hope someone here can help me out.
I did a new install of SQL Server 2000 on a fresh NT PC. If I use Enterprise manager or Query Analyzer to connect, it will work fine as log as I am working locally. If I try to use the same tools from a different machine, I get the "Server does not exist or access is denied" error. I have tried using SQL Server authentication as well as Windows Authentication. I have created new users as well as logging in to the remote machine as admin(the login used for the SQL machine) I am just stuck. If anyone has an idea, please let me know. I thank you.
Bill

 

[JHoarty]

Try pinging the server from your remote PC. For example, if you are trying to connect to instance "CUSTDB" on server "CUSTPC", try to ping "CUSTPC" from the workstation.

You might also try checking for a user dsn in the ODBC datasources applet in Control Panel. Try adding one, see what happens there.

John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com

 

[foxdev]

Bill, what protocol(s) do you have the server listening on?
What protocol are you trying to use from the client (use the Client Network Utility or ODBC setup to check it)?

You may be using the Named Pipes default; try switching to TCP/IP and see what happens. -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:

http://www.lowcostprints.com

http://www.foxdev.com

 

[woyler]

I can see it. The server I am trying to connect to is an available option to select in everything from creating a DSN to enterprise manager. I am using TCP/IP. It is when I go to connect that I get
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied"