Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I just installed Sql 2008 Express on a new server running Windows Server 2008. I know Sql is working properly, because I can connect to the db fine locally, on the server. I cannot connect to it from a client machine though, neither by IP address nor by machine name (iporname\instance).

I know I have the correct IP address, because I am RDCing into the server to perform all this configuration and setup, and if I ping the server name, it is resolving to the correct IP address as well.

On the server, I have set up an inbound firewall exception allowing all traffic on any port on any protocol to sqlservr.exe.

In SSMS, in server > Properties > Connections Allow remote connections to this server is enabled. In Sql Server Configuration Manager, TCP/IP is enabled in both the Protocols for <instance> and the Client Protocols sections.

I looked in the Windows logs, but don't see anything about connections being denied or dropped. As far as I can see, I have everything set right, but cannot connect from a client machine. The client CAN connect to other Sql 2008 Express servers okay, so I know the client configuration is correct.

Any ideas where else I can look for info of what/where/how this connection is dropping, greatly apprecaited!

The error being returned by the client is:

**TITLE: Connect to Server**

Cannot connect to [MY.IP.ADD.RSS]\[MYINSTNAME].

ADDITIONAL INFORMATION:

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 SQL Server is configured to allow remote connections. 
(provider: SQL Network Interfaces, error: 26 Error Locating Server/Instance Specified)
(Microsoft SQL Server, Error: -1)
share|improve this question
add comment

1 Answer

up vote 3 down vote accepted

You need to start the SQL Browser service, and configure the firewall to all UDP 1434 traffic to the SQL Browser service. This service is what allows the SQL client software to figure out which TCP port the named instance is listening on.

share|improve this answer
    
THANK YOU! Very much! I had the broswer service started, but did not have the UDP port exception. That did it. Thanks! –  eidylon Feb 15 '11 at 22:30
    
no problem. Glad to help. –  mrdenny Feb 15 '11 at 22:31
    
Congrats on the MCM. That's awesome! :) –  squillman Feb 16 '11 at 14:36
    
Thanks @squillman. –  mrdenny Feb 16 '11 at 17:33
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.