asked on
How to troubleshoot SQL network resolution
Hello Experts,
I have a network that has a Win Server 2008r2 with SQL 2008r2 AND a Win Server 2008r2 for a DC. The environment has worked well until this morning.
There is an application that connects to the database and for some reason some workstations cannot find the database while others can. Then the ones that cannot will work and then will have a problem again. I looked at the server and I don't see any bad events.
From the workstation, I can ping the SQL server, perform an NSLOOKUP to the server and can sometimes telnet (telnet servername 1433) to the server.
What can I do to pin point the problem?
The clients are win xp and win7
I have a network that has a Win Server 2008r2 with SQL 2008r2 AND a Win Server 2008r2 for a DC. The environment has worked well until this morning.
There is an application that connects to the database and for some reason some workstations cannot find the database while others can. Then the ones that cannot will work and then will have a problem again. I looked at the server and I don't see any bad events.
From the workstation, I can ping the SQL server, perform an NSLOOKUP to the server and can sometimes telnet (telnet servername 1433) to the server.
What can I do to pin point the problem?
The clients are win xp and win7
Microsoft SQL ServerWindows Server 2008
Last Comment
tucktech
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I found the problem. I assumed I would be able to ping the server name. I could not, the ip address was not ping-able. I have two nic cards in the server and I had to disable the NIC card that was the secondary IP address. Using Windows 2008r2 so I don't see a NIC teaming option.
ASKER
Giving all of you credit because you started down the correct path of debugging... I also ran across this web page that I found helpful..
http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx
http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx
ASKER
This helped...
http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx
Thanks for your infomraiton and fundamental question, it always go back to fundamentals!
http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx
Thanks for your infomraiton and fundamental question, it always go back to fundamentals!