Posted on: 5/2/2014 6:35:36 AM | Views : 469

These are the steps that I took:
1. Enable Force Encryption "Yes" , and chose SSL Cert, unable to start.
2. Enable Force Encryption "No", still unable to start
3. Deleted the thumbprint value of the certitificate from "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\MSSQLServer\SuperSocketNetLib\".
and restart the SQL service.  Still unable to start.

Error from SQL Logs are as follows:
2014-05-02 18:26:34.72 Server      Error: 17182, Severity: 16, State: 1. 2014-05-02 18:26:34.72 Server      TDSSNIClient initialization failed with error 0x2, status code 0x38. Reason: An error occurred while obtaining or using the certificate for SSL. Check settings in Configuration Manager. The system cannot find the file specified.
2014-05-02 18:26:34.72 spid10s     Starting up database 'model'. 2 ...

Go to the complete details ...