February 28, 2020 at 8:38 pm
Hello experts,
A client is reporting the following error when his application tries to connect to one of our QA SQL Servers. Could someone advise me on how to troubleshoot this issue? Sorry I don't know more about certificates, but I confess I am not even sure where to start.
Client unable to establish connection (SQL-08001)
[unixODBC][Microsoft][ODBC Driver 11 for SQL Server]SSL Provider: [error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed:self signed certificate] (SQL-08001)
Thanks for any help!
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
February 29, 2020 at 9:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
March 2, 2020 at 10:53 pm
Are you using SSL? Knowing that would be a good place to start. The error is for a self signed certificate and if you are using those and SSL, the connection strings need to include TrustServerCertificate=True. If others can connect, compare the connection strings being used.
Sue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply