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 ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.