Solved

How to troubleshoot SQL network resolution

Posted on 2016-09-16
4
74 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 15

Accepted Solution

by:
Megan Brooks earned 500 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

728 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