asked on

MSSQL Server 2008 R2 Named Pipes Error

I have installed MSSQL Server 2008 R2 but I am having trouble connecting to it remotely. I am able to ping the server, enabled TCP/IP and Named Pipes, enabled remote connections, setup exceptions for port 1433, started SQL Server browser but still no luck. what am i missing?

exact error message
TITLE: Connect to Server
------------------------------

Cannot connect to 172.20.244.85.

------------------------------
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 that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

SOLUTION

lcohan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

szadroga

ASKER

I'm not sure, i wasn't the one who installed SQL Server. Is there a quick way for me to find out?

I opened the link and proceeded to the section 'To determine the name of the instance of the Database Engine" and after performing Step 4 i got the following error message. Does this mean it is not "Instance"?

TITLE: No Local Servers Found
------------------------------

No local servers of type 'Database Engine' were found.

------------------------------
BUTTONS:

OK
------------------------------

lcohan

Can you access that actual box where SQL Server was installed via RDP and check the Services to see the actual SQL Server Service name?

ASKER CERTIFIED SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

szadroga

ASKER

attached is a screenshot of my services. does this indentify SQL Server Service Name?
services.png

szadroga

ASKER

Dave,

I am able to connect to other MS SQL SERVERS via my machine. Would i still need to install SQL Native Client?

Dave Baldwin

Probably not if they are the same version. You can look in the ODBC manager to see what drivers you have.

The services you are showing should be running on the machine with the SQL Server. SQL Native Client is a driver, not a service, so it would not show up in that list. It should show up in the ODBC Manager.

szadroga

ASKER

Dave,

I went to the download link but there are several file choices to download. Which one should I choose? My machine is Windows 7 64 bit. The MS SQL Server is 2008 R2 64 bit.

szadroga

ASKER

attached is a screenshot of my drivers
drivers.png

Dave Baldwin

Yep, there are two versions there. One of the things about using the drivers is that you have to Exactly quote the name for it to be recognized and use. For the SQL Native Client listed, you must call it "SQL Server Native Client 10.0" to be recognized.

Dave Baldwin

I forgot to mention that you can make a "User DSN" using that driver and the credentials that you are trying to use to see if the connection works.

szadroga

ASKER

Still no luck. I tried creating a USER DSN connection using the SQL Server Native Client driver i have installed and got an error message (see attached). Do i need to update my drivers for SQL Native?
error.png

Dave Baldwin

No, you don't need to update your driver. You may have to go into the Admin page for the SQL Native Client and make sure that TCP connections are enabled. Or you may have to turn on TCP and remote connections on this particular server.

How are you connecting to other SQL instances?

szadroga

ASKER

Dave,

When you mention the SQL Native Client, is that on my machine or server? On the server, i have the TCP enabled and "allow remote connections" (see attached screenshot)
settings.png

szadroga

ASKER

I am connecting to other SQL servers using SSMS 2008 on my local machine .

Dave Baldwin

When you mention the SQL Native Client, is that on my machine or server?

It is installed on the server with the SQL Server. However, you need a copy on your machine to make the connection. You program isn't going to 'remotely' use the version on the server.

But as you showed above, you do have it on your machine which is why you can connect to other machines with SQL Server. In your image above, look at the SQL Server protocols to see if they match the SQL Native Client protocols, in particular make sure TCP is enabled.

szadroga

ASKER

Issue had to do with firewall on my side.

Both experts provided great tips for troubleshooting this type of error message