Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to troubleshoot SQL network resolution

Posted on 2016-09-16
4
Medium Priority
?
87 Views
Last Modified: 2016-09-19
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
0
Comment
Question by:tucktech
  • 3
4 Comments
 
LVL 16

Accepted Solution

by:
Megan Brooks earned 2000 total points
ID: 41802380
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
 

Author Comment

by:tucktech
ID: 41802997
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
 

Author Comment

by:tucktech
ID: 41802998
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
 

Author Closing Comment

by:tucktech
ID: 41804790
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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question