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.  
Need Help
  • 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.

v-veshwara-msft's avatar
v-veshwara-msft
Community Support
1 year ago

Hi z3pp4 ,

Just checking in to see if your issue has been resolved and if the response from rohit1991  was helpful.

If not, please feel free to reach out for further assistance.

Thank you, and thanks rohit1991  for addressing this earlier.