Forum Discussion

z3pp4's avatar
z3pp4
Regular Visitor
1 year ago
Solved

SQL Connection Error: received certificate has expired

Hello guys, 

 

I'm trying to connect to a SQL Server, but ending up getting this error.

 

Can anyone help me on this one?

 

Thanks in advance.

 

  • rohit1991's avatar
    rohit1991
    1 year ago

    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.