Home » Blog » Topic » How to Fix this SQL Network Interfaces Error 26 on SQL Server 2008 r2 ?

How to Fix this SQL Network Interfaces Error 26 on SQL Server 2008 r2 ?

Stephen West ~ Modified: May 18th, 2016 ~ ~ 1 Minute Reading

Home › Forums › How to Fix this SQL Network Interfaces Error 26 on SQL Server 2008 r2 ?

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • May 18, 2016 at 1:36 pm #2090 Score: 0
    Stephen West
    Moderator
    4 pts

    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)

    May 20, 2016 at 7:11 am #2097 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

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

    May 23, 2016 at 11:13 am #2101 Score: 0
    Henry Davidson
    Moderator
    31 pts

    Do you have the browser service enabled?

    May 26, 2016 at 11:43 am #2113 Score: 0
    Stephen West
    Moderator
    4 pts

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

    May 27, 2016 at 10:41 am #2117 Score: 0
    Kerry Morris
    Moderator
    33 pts

    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.

    May 31, 2016 at 11:46 am #2131 Score: 0
    Barry Alllen
    Moderator
    25 pts
    • Create an empty text file called test.udl
    • Specify your connection properties
    • Click Test Connection button.
    June 6, 2016 at 12:32 pm #2209 Score: 0
    Andrew Jackson
    Moderator
    1 pt

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

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.