Forum Discussion
SQL Connection Error: received certificate has expired
- 1 year ago
Hi z3pp4
1. Check the SQL Server's CertificateAsk your IT or DB admin to check the installed certificate’s expiry.
You can also check via mmc >> Certificates >> Personal >> Certificates on the server.
2. Update/Renew the Certificate
Generate and install a new SSL certificate.
Use SQL Server Configuration Manager >> Protocols for MSSQLSERVER >> Properties >> Certificate tab to apply it.
3. Restart SQL Server
After applying the new certificate, restart the SQL Server service for changes to take effect.
Hi z3pp4
1. Check the SQL Server's Certificate
Ask your IT or DB admin to check the installed certificate’s expiry.
You can also check via mmc >> Certificates >> Personal >> Certificates on the server.
2. Update/Renew the Certificate
Generate and install a new SSL certificate.
Use SQL Server Configuration Manager >> Protocols for MSSQLSERVER >> Properties >> Certificate tab to apply it.
3. Restart SQL Server
After applying the new certificate, restart the SQL Server service for changes to take effect.