x

Remote connection fails after DNS and DCHP server down

I appreciate answers to help me troubleshot remote connection issue after DNS and DCHP server down I got today.

I have 2 instances on a same server. I open 1433 and 1435 for SQL connection throuth firewall. I also open 1434 for UDP through firewall. I configure TCP and Named Pipes enabled. Before today, remote computers could connect to both instances by IP and instance name.

Today DNS and DCHP server down for a while. After DNS and DCHP server up again, remote computers can only connect both instance by IP. SSMS and ODBC can find instance names, but cannot logon. I got SQL Server error 6.

Thanks in advance.
more ▼

asked Sep 15, 2011 at 08:23 PM in Default

DBA 1 gravatar image

DBA 1
11 1 1 2

When you ping the server by name, does it resolve to the correct IP address?
Sep 15, 2011 at 08:48 PM KenJ
Are you using windows authtication?
Sep 16, 2011 at 06:21 AM sp_lock
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
I would suggest disabling named pipes on whatever client you are using for testing but only becuase I think the TCP connection is easier to understand / troubleshoot. I would run open a comment prompt on your test client and run ipconfig /flushdns
first, followed by nslookup <name of server>
Name of server should NOT include the instance name, the nslookup should respond with the IP address of the server. If it does then try the SQL connection again. If nslookup fails then DNS is still not working, in this case I'd start by checking the eventlogs on the DNS server. If nslookup works then there is someother issue with SQL Server. (Try a reboot?)
more ▼

answered Sep 19, 2011 at 01:16 AM

pipthegeek gravatar image

pipthegeek
329 1 2 5

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x47

asked: Sep 15, 2011 at 08:23 PM

Seen: 966 times

Last Updated: Sep 15, 2011 at 08:23 PM