SQL Server Remote Access Error

Question

Installed SQL Server 2014 Enterprise version on two computers, trying to remotely access the database in one of the computers through the other.

Getting this error message:

A network related or instance specific error occurred while established a connection to SQL Server. The server was not found or accessible. Verify that instance name is correct and SQL Server is allowed to connect through remote connection (provider:-namedpipeprovider, error:-40, could not open a connection to SQL Server (Microsoft SQL Server, error-2)

From my online research, I did the following things

Checked if SQL Server and browser service is running.
Changed the port numbers in the windows firewall for inbound/outbound connections
Enabled TCP/IP ports

Not sure how to rectify the error, please help!

Thanks in advance!

Start by making sure you can ping the server. That will tell you if it is a problem seeing the computer or a problem with the connection. — Sean Lange, Jul 31 '15 at 18:52

score 1 · Answer 1 · edited May 23 '17 at 12:10

1

Check out the answer in this post. it's pretty in-depth as to what all needs to be setup correctly. By default SLQ Server is pretty well locked down for local access only.

Why am I getting "Cannot Connect to Server - A network-related or instance-specific error"?

edited May 23 '17 at 12:10

Community

1
1

answered Jul 31 '15 at 18:55

Mike Chilson

91
1
2

1

This is really more of a comment than an answer but +1 anyway because that is a good thread on the topic. :) – Sean Lange Jul 31 '15 at 18:56
Thanks Mike,I looked into it.when i run sqlcmd -L.its showing a blank screen.not sure why? – Give_me_data Jul 31 '15 at 19:03

score 0 · Answer 2 · answered Apr 12 '17 at 05:57

To connect to SQL server from another computer, You might need 2 more steps:

Change port numbers in the firewall is not enough, make sure that you have enabled TCP/IP connections in SQL Server Configuration Manager
Configure SQL Server to listen on the specific port that you need.

SQL Server Remote Access Error

2 Answers2