In this blog post, let’s learn about the error message “49965 – Unable to load cluster root CA certificate due to OSError:’%s’.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
49965 – Unable to load cluster root CA certificate due to OSError:’%s’.
Reason for the Error
The SQL Server error 49965 occurs when SQL Server is unable to load the cluster root CA certificate due to an operating system error. Here are some of the possible causes of this error:
- The root CA certificate file is missing or corrupt: If the root CA certificate file is missing or corrupt, SQL Server will not be able to load the certificate.
- The certificate is password protected: If the root CA certificate is password protected, SQL Server will not be able to load the certificate unless the correct password is provided.
- The certificate file path is incorrect: If the path to the root CA certificate file is incorrect, SQL Server will not be able to load the certificate.
- Permissions issues: If the SQL Server service account does not have the necessary permissions to access the root CA certificate file, SQL Server will not be able to load the certificate.
Solution
To fix this error, you can try one of the following solutions:
- Verify that the root CA certificate file exists and is not corrupt. You may need to obtain a new certificate file if the current file is corrupt.
- Ensure that the certificate is not password protected or provide the correct password to load the certificate.
- Check the certificate file path to make sure it is correct. If the path is incorrect, update it to point to the correct location.
- Verify that the SQL Server service account has the necessary permissions to access the root CA certificate file.
- Restart the SQL Server service: Sometimes, restarting the SQL Server service can fix the issue. Restarting the service can free up any resources being used by SQL Server and may resolve the issue.