I have a Windows 2003 Server with SQL Server 2000 installed. On the server itself I can create a DSN to connect to the localhost, but on any other machine I can't. I tried to telnet to 1433 from the command prompt but get no connection.
There are couple of things you can check. The most obvious ans posibly stupid question is "Have you check to see if the server is on the Network?" Can you ping other servers from your SQL Server?
Check the Client network utility on the server and make sure there is no alias created for that server.
Try to connect via named pipes. If you can then the problem is connecting via TCP. You can change to named pipes in the Client config options of your DSN
Check the Server Network utility TCP/IP Properties. Make sure it is listening on 1433.
Check your SQL Server error log for errors.
- Paul
- Database performance looks fine, it must be the Network!
That means the only way to fix a firewall issue is to contact the network team and have them dig a hole for you to communicate through.
Sorry we can't help you more than that.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.