Share via

Excel cannot connect to SQL Server with error: [DBNETLIB] [ConnectionOpen (SECDoClientHandshake()).] SSL Security Error

John Lyndon Philip L. Planas 0 Reputation points
2023-05-25T09:08:38.0466667+00:00

One of our customers are having problems in connecting from Excel to SQL Server Database Engine and Analysis Services.

Please see images below:

When trying to connect to SSAS this error occurs

Errors in the OLE DB provider.Could not connect to the redirector.Ensure that the SQLBrowser service is running on the 'utcidoit01" server

Then when trying to connect to SQL DB, this error occurs

User's image

We have read that the error is related to TLS?

Then we found out that the machine where the SQL Server is installed uses TLS 1.2 and the machine where the excel is installed used TLS 1.2. The other versions of TLS are disabled.

Hope someone can help us.

Thanks!

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,344 questions
Microsoft 365 and Office Excel For business Windows
SQL Server Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Claudio Emilio Ale 1 Reputation point
    2023-05-25T09:49:26.4833333+00:00

    Hi John,

    Can you give more details about the connection? (which ODBC driver uses and the steps that you realize to connect to the database for example).

  2. ZoeHui-MSFT 41,491 Reputation points
    2023-05-26T06:27:44.9033333+00:00

    Hi @John Lyndon Philip L. Planas，

    Starting with SQL Server 2016 (13.x), Secure Sockets Layer (SSL) has been discontinued. Use TLS (TLS 1.2 is recommended) instead. For more information, see KB3135244 - TLS 1.2 support for Microsoft SQL Server

    Here is a same thread, you may take a reference to.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.