locked
Event ID 5586. Unknown SQL Exception 67 occurred. RRS feed

  • Question

  • Hi,

    Our IIS server started to get this event id 5586 error intermittently (not always). sometimes, error happen numerous time within a day, other time once every couple of days. Has been researching however do not have much luck.

    Help is appreciated on how to troubleshoot this issue, and whether it is a network related or server or SP issue?Log Name:      Application
    Source:        Microsoft-SharePoint Products-SharePoint Foundation
    Date:          1/9/2013 5:19:25 PM
    Event ID:      5586
    Task Category: Database
    Level:         Error
    Keywords:      
    User:          NT AUTHORITY\admin
    Computer:     IISServer01
    Description:
    Unknown SQL Exception 67 occurred. Additional error information from SQL Server is included below.

    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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{}" />
        <EventID>5586</EventID>
        <Version>14</Version>
        <Level>2</Level>
        <Task>3</Task>
        <Opcode>0</Opcode>
        <Keywords>0x4000000000000000</Keywords>
        <TimeCreated SystemTime="2013-01-09T09:19:25.192504000Z" />
        <EventRecordID>191695</EventRecordID>
        <Correlation ActivityID="{}" />
        <Execution ProcessID="6208" ThreadID="9972" />
        <Channel>Application</Channel>
        <Computer>IISServer01</Computer>
        <Security UserID="" />
      </System>
      <EventData>
        <Data Name="int0">67</Data>
        <Data Name="string1">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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)</Data>
      </EventData>
    </Event>

    thank you


    Best Regards,

    Friday, January 25, 2013 6:07 AM