June 10, 2011 at 2:36 pm
when tried to connect to sql server 2008,
got the below error message.Can any one suggest me solution?
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)
June 10, 2011 at 4:23 pm
Most likely is that you did not have the SQL Server instance name incuded in the server name. It also may have been spelled wrong.
If you are accessing a default instance on the local machine, the name will be the local machine name.
Accessing a remote, default instance requires that you type in the machine name.
If you are accessing a named instance you have to type the name as: <machinename>/<instancename>.
If the SQL Server isntance is no a different machine, and you have typed everything in properly, you may have networking issues.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply