Home Forums SQL Server 2005 Administering Not able to restart the MSSQL Server Services RE: Not able to restart the MSSQL Server Services

  • August 25, 2016 at 3:53 am

    #1897420

    All,

    I had the same issue recently with 2008R2. Exact same symptoms as above. Here's how I fixed it:

    1. Export "Regedit - HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp\" registry

    2. my "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp\IPAll" had a registry key "TCPPort" = "1443,45004"

    3. I changed that string to "1443"

    4. Start the SQL service

    Working again!