4

I can't connect to a remote SQL Server.

I get this error:

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

On the remote machine, the SQL Server is running and port 1433 is open.

In my Visual Studio Server Explorer, the data connection to the remote database shows a little red cross. The state is closed. - I can't see the remote pc in the server name select field. But I can successfully ping the remote computer.

How to connect to the server?

EDIT:

My connection string: {Data Source=wsbd0311\SQLEXPRESS;Initial Catalog=rms;User ID=sa;Password=mypassword} (I can login with this Id and password.)

I allready set "Allow remote connctions to this server" on the remote SQL Server.

EDIT No.2:

Do I need to have an open port 1434 on the remote SQL Server?

kame
  • 20,848
  • 33
  • 104
  • 159

2 Answers2

1

Make sure the server is running on the remote pc. Connect to the remote pc and check whether the SQL server instance is running on it by All Programs -> SQL Server -> SQL Server Configuration Manager -> Under SQL Server Services check whether the SQL Server service is on running state. If not try starting the service and connecting. Furthermore Enable TCP/IP under the Protocols for MS SQL Server which comes under SQL Server Network Configuration.

ChathurawinD
  • 756
  • 1
  • 13
  • 35
0

You may be able to ping the server if the machine is turned on, but in order to connect to the SQL server instance, you should make sure that the SQL server is up and running on the server machine. Check this link for more details

How to Start, stop or restart SQL Server Instance

Jayasurya Satheesh
  • 7,826
  • 3
  • 22
  • 39
  • I wrote that the SQL server is running. I see a green dot with a white triangle in it. – kame Oct 24 '17 at 05:53
  • Assuming both server and the client machine are on the same network, make sure that you have enabled remote logic for SQL Server in the Server configurations : https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-access-server-configuration-option – Jayasurya Satheesh Oct 24 '17 at 06:26
  • Check the below Links : https://stackoverflow.com/questions/13754563/sql-network-interfaces-error-26-error-locating-server-instance-specified https://www.codeproject.com/Questions/310806/provider-SQL-Network-Interfaces-error-Error-Loc https://forums.asp.net/t/1499314.aspx?error+26+Error+Locating+Server+Instance+Specified Hope they might help – Jayasurya Satheesh Oct 24 '17 at 07:03