Question

Yuva Swapna on Wed, 18 Jun 2014 08:36:19


Hi,

In my application when i try to connect to my .mdf file I got the below error. When I checked for documentation on this error @ http://technet.microsoft.com/en-us/library/cc645603(v=sql.100).aspx

I couldn't find the same in the list.

Error Details : "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)"

Is this missed to document? Can you please confirm.

Please help me in finding documentation on this error.

Thanks

Swapna



Sponsored



Replies

tracycai on Thu, 19 Jun 2014 05:44:29


Hi,

Thank you for posting in SQL Server Forum.

“SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified” is a common error message when connecting to a SQL Server.

Is it a local instance or remote instance? Default instance or Named instance? What’s the SQL Server version and edition?

The possible cause of this issue could be SQL Server Database Engine is not running, when the server name was typed incorrectly, or when there are network problems or firewalls.

Please check the following suggestions for troubleshooting this issue:

1. Make sure SQL Server Service is running

2. If a named instance, make sure SQL Server browser service is running

3. Make sure SQL Server is configured to allow remote connections

4. Check the SQL Server error log. View the SQL Server error log by using SQL Server Management Studio or any text editor. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.

Here is the document regarding how to troubleshoot the error message.

http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

http://technet.microsoft.com/en-us/library/ms190181(v=sql.105).aspx

Thanks.