SQL Connection Error: received certificate has expired

[z3pp4]

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.

[v-veshwara-msft]

Hi @z3pp4 ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

[v-veshwara-msft]

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.

[Jai-Rathinavel]

@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]

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.

[rohit1991 · Accepted solution]

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.