SQL Server Connection

5 pts.
Tags:
T-SQL
Windows Server 2003
Windows XP
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.
ASKED: February 18, 2008  8:33 AM
UPDATED: February 18, 2008  4:47 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following