troubleshooting Question

How to troubleshoot SQL network resolution

Avatar of tucktech
tucktech asked on
Microsoft SQL ServerWindows Server 2008
4 Comments1 Solution134 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Megan Brooks
SQL Server Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros