locked
Error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. error: 26 - Error Locating Server/Instance Specified RRS feed

  • Question

  • Hi,

    We are facing performance issues with SP 2007 environment

    When a request is made, am getting this error in the event log:

    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)

    System Log:

    The Security System could not establish a secured connection with the server "xxxx". 
    No authentication protocol was available.

    Please help me with your expert suggestion


    Venkatesan Nadimuthu

    Friday, September 25, 2015 3:45 PM

All replies

  • Hi,

    Would suggest to Enable Developer Dashboard to check which component of the Site is requesting information from the server and how many times.

    Also you can configure Fiddler to check the network traffic (HTTP).

    Hope this helps:)

    Monday, September 28, 2015 7:47 AM
  • Hi, Unfortunately there is no Sharepoint Developer Dashboard available for Sharepoint 2007 environment. Network is fine. No issues found

    Venkatesan Nadimuthu

    Thursday, October 15, 2015 12:56 PM