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.

5 Replies

  • rohit1991's avatar
    rohit1991
    Super User
    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.

  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    Super User
    1 year ago

    z3pp4 I believe your machine's firewall is blocking the connection, can you check if you are able to connect to SQL Server using Dataflow Gen 1 or Gen 2 on service ?. If you are able to connect on service then you can confirm that the issue is with the firewall configurations.

     

    Thanks,

    Jai

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

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