RATE THIS ANSWER
0
Click to Vote:
- 0
0
Last Answered:
Feb 18 2008 4:47 PM GMT
by WillC
From bad workstation you can ping the server, by name or IP?
I have seen this type of problem that I think I know where I am pinging but DNS or other network Name Service is messing things up.
To verify the ping connect to the server and get the IP address it is using. From the bad workstation ping that IP and add the -a switch to have the name resolved. You could also try flushing the DNS cache in the workstaion and include the arp recored too:
ipconfig /flushdns
arp -d
Then check your NIC setting to see if the subnet mask or default gateway are correct.
You have not mentioned what version of SQL you have on the client and server, are they compatable?
T-SQL, Windows XP, Windows Server 2003
I'm having a problem with one of my workstation which cannot connect to SQL server instance, while the other workstation can connect. The server is running on Window Server 2003 while the other client are running on window xp proffessinal. the fanny thing is i can ping the server but the application cannot connect to the SQL server instance. 
