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.

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