Documentation Index

Fetch the complete documentation index at: https://documentation.winmagic.com/llms.txt

Use this file to discover all available pages before exploring further.

1990 Microsoft SQL Server Login SQL State 01000 Error 817

Prev Next

The following Error message might appear in certain circumstances, when trying to access the SES console:

Connection failed:
SQLState '0100'
SQL Server Error 817
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(SECDoClientHandshake()).
Connection failed:
SQLState: '08001'
SQL Server Error. 18
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error

From the error message it looked like a TLS issue, where one component is using TLS 1.0 and the other TLS 1.2 or like a cipher mismatch

Tools and websites that were used in the troubleshooting process:

https://learn.microsoft.com/en-us/windows/win32/secauthn/cipher-suites-in-schannel

https://www.nartac.com/Products/IISCrypto/

In SES you can set aswell the TLS settings:

https://stackoverflow.com/questions/65499019/odbc-sql-server-driverdbnetlibssl-security-error-18

https://danarman.blogspot.com/2023/02/windows-11-unable-to-connect-to-sql.html

https://support.microsoft.com/en-us/topic/kb3135244-tls-1-2-support-for-microsoft-sql-server-e4472ef8-90a9-13c1-e4d8-44aad198cdbe

In the end it turned out, that the customer had upgraded ODBC drivers to Version 18, after rolling back to 17, the issue was resolved