Remote SQL server connection failure
Posted
by
Sevki
on Server Fault
See other posts from Server Fault
or by Sevki
Published on 2010-03-17T21:02:32Z
Indexed on
2012/04/01
5:31 UTC
Read the original article
Hit count: 608
sql-server-2008
I am trying to connect to my MSSQL server 2008 web instance and im failing horribly... i get the error 26 and before you jump on me i have done these
- Check the spelling of the SQL Server instance name that is specified in the connection string.
- Use the SQL Server Surface Area Configuration tool to enable SQL Server to accept remote connections over the TCP or named pipes protocols. For more information about the SQL Server Surface Area Configuration Tool, see Surface Area Configuration for Services and Connections.
- Make sure that you have configured the firewall on the server instance of SQL Server to open ports for SQL Server and the SQL Server Browser port (UDP 1434).
- Make sure that the SQL Server Browser service is started on the server.
in addition to theese i have disabled the firewall completely and tried other ports nothing works the same credentials work on the server but not on the client.
this is the exact error message
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) (.Net SqlClient Data Provider)
Can anybody help?
© Server Fault or respective owner