Unable to connect to sql server 2008

Hi All,

I have a few sql 2008 servers on windows 2008 and except to one of them I am unable to connect to these instances from my local machine(which is sql 2005 sp3 on winXP) . I also tried from my laptop which has sql 2008 installed on it but with no luck. Here is the message I get:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Since there is no trust between the two domains I am using sql logins to connect to the servers in question. And here is what I tried so far: I check 1433 port is open, I turned on sql browser, I checked the firewall is not blocking.

BTW I am not also able to connect to these 2008 instances from 3rd party tools that I use to monitor my servers.

Please let me know if you have any solutions.


more ▼

asked Mar 30, 2010 at 11:06 AM in Default

avatar image

4.9k 33 39 43

What service account is running SQL Server?

Mar 30, 2010 at 02:11 PM sp_lock

For one instance SQL server is running as local system and other services including sql browser are running as NT AUTHORITY\LOCAL SERVICE. The other instances in question are running under NT AUTHORITY\LOCAL SERVICE.

Mar 30, 2010 at 02:51 PM DaniSQL

Have you checked the SAC utility?? Make sure it is accepting connections for the engine and browser.

Mar 30, 2010 at 04:39 PM sp_lock

Yes I checked and it was configured correctly. Thanks!

Mar 30, 2010 at 05:16 PM DaniSQL
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I asked the network and server team to turn off the firewall briefly so that I can try connecting and rule out if it is not the firewall. I was able to connect to the instances. That was strange because port 1433 was already open and mycoworkers are connecting to the instances and the problem happens only with my machine. Once I know for sure it has something to do with firewall I asked the server team to reconfigure their firewall. We created an exception and let SQL server instances listen to requests that comes from my IP and everything worked just fine.

more ▼

answered Mar 30, 2010 at 05:15 PM

avatar image

4.9k 33 39 43

(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Mar 30, 2010 at 11:06 AM

Seen: 4581 times

Last Updated: Mar 30, 2010 at 11:13 AM

Copyright 2018 Redgate Software. Privacy Policy