Thursday 26 May 2022

SQL server 2014 SP1 services not starting after clean installation

Environment:

Installed SQL server 2014 few times on same machines and difference machines but the SQL services were not starting.

 while trying to start the services, getting the following errors.

Error:

"The SQL Server (MSSQLSERVER) service terminated with the following service-specific error:  The group or resource is not in the correct state to perform the requested operation."

Error:

"“Windows could not start SQL Server (SQLEXPRESS) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 5023.”"

Solution: 

Download the latest patches (SQLServer2014-KB4019099-x64 ) from  the following link to update the SQL

"KB3135244 - TLS 1.2 support for Microsoft SQL Server"


Referance 

1: Microsoft SQL Sever 2014 Express Advanced SP2 (version 12.2.5000.0) fails to start after TLS 1.0 is disabled. - Microsoft Q&A

2: TLS 1.2 Support for SQL Server 2008, 2008 R2, 2012 and 2014 | Microsoft Docs

3: KB3135244 - TLS 1.2 support for Microsoft SQL Server