How to Fix This SQL Network Interfaces Error 26 on SQL Server 2008 R2 ?

Resolved SQL
CM
Community Member
May 18, 2016
6 replies
984 views
Reviewed by moderators

Hello Experts, I just installed SQL Server 2008 R2 but I'm not able to connect it via SQL Server management studio. I'm getting below 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) (Microsoft SQL Server, Error: -1)
6 Answers
Accepted Answer
Verified by Edwin J. Hoffer, Expert · Reviewed May 2016

check if the Server Name is incorrect or misspelled. e. g. no typo on the name

Do you have the browser service enabled?

Thanks Lincoln and Henry for the replaynThe Server name is correct and the browser service is enabled as well.

Sometimes error 26 - error locating server/instance specified occurs because Mixed-mode authentication is disabled. Please make sure that Mixed-mode authentication is enabled on SQL Server, which you are trying to connect.

    n
  • Create an empty text file called test. udl
  • nn
  • Specify your connection properties
  • nn
  • Click Test Connection button.
  • n
nn

The following link provides possible causes of the error with solutions nhttp://www. sqlserverlogexplorer. com/fix-error-code-26/ n