SQL Server Failed to Listen on IP Any

  • We had the following issue today:

    Application faile dto connect to the DB. An attempt was made to restart the SQL Server Service but failed.The service was eventually started using the Local System account then the original service account was added to the administrators group and used to start te service.

    On examining the logs, we found the following ke errors:

    [font="Courier New"]05/23/2012 13:26:56,Server,Unknown,SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.,

    05/23/2012 13:26:56,Server,Unknown,Could not start the network library because of an internal error in the network library. To determine the cause<c/> review the errors immediately preceding this one in the error log.,

    05/23/2012 13:26:56,Server,Unknown,TDSSNIClient initialization failed with error 0x2747<c/> status code 0xa.,

    05/23/2012 13:26:56,Server,Unknown,TDSSNIClient initialization failed with error 0x2747<c/> status code 0x1.,

    05/23/2012 13:26:56,Server,Unknown,Server failed to listen on 'any' <ipv4> ****. Error: 0x2747. To proceed<c/> notify your system administrator.,[/font]

    Does anyone know what this all means. My search is pointing to sometin having to do with Named Pipes but it is just not clear.

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • Hi,

    This link will be able to help you:

    http://blogs.msdn.com/b/sql_protocols/archive/2006/01/10/511330.aspx

    Phillip Cox

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply