Microsoft SQL: A connection was successfully established with the server, but then an error occurred

yes, lots of it.  Have them restart the SQL server service to pick up the renewed certificate. There will be much kicking and screaming (lots of it!) but you need to persist.

 

You could also blindly trust the certificate but that is sub-optimal.

Hi sgallo ,

Thank you for reaching out to the Microsoft Fabric community.

Restarting the SQL Server service is essential to ensure the server recognizes the renewed certificate. Confirm that the installed certificate is issued by a trusted Certificate Authority and is not expired. If the certificate is self-signed or untrusted, you may temporarily use TrustServerCertificate=True in the connection string.

However, this is not advisable for production environments. Instead, install a trusted SSL certificate from a recognized Certificate Authority to securely resolve the issue. After implementing these changes, test the connection to ensure it is functioning correctly. If the issue persists, check for network or firewall problems.

 

Thank you for your quick response lbendlin .

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hi sgallo ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Hi sgallo ,

Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.