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
tucktechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Megan BrooksSQL Server ConsultantCommented:
Two initial questions:
Are you seeing login failures in the SQL Server log? If so, what does it say?
Is the application using WIndows or SQL Server authentication?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tucktechAuthor Commented:
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.
0
tucktechAuthor Commented:
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
0
tucktechAuthor Commented:
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!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.