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 ,

Following up to see if your query is resolved and if any of the responses helped.
If you're still facing issues, feel free to reach out.

Thank you.