Error connecting MicroStation to SQL Server through ODBC


 Product(s):MicroStation
 Version(s):08.11.09.919
 Environment:Windows Server 2016
 Area:Database
 Subarea:ODBC

Problem

User gets the following error

 

Connection Failed:
SQLState: '01000'
SQL Error: 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (SECCreateCredentials()).
Connection failed:
SQLState: '08001'
SQL Error: 18
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error

Machine Details
Operating System – Windows Server 2016
SQL Server version - 2017
MicroStation version – 08.11.09.919
ODBC version and bit (32/64) – N/A

Solution

Several known vulnerabilities have been reported against SSL and earlier versions of Transport Layer Security (TLS 1.0, TLS 1.1). We recommend that you upgrade to TLS 1.2 for secure communication.

https://support.microsoft.com/en-us/help/3135244/tls-1-2-support-for-microsoft-sql-server
 
Download the latest ODBC Driver for SQL Server that support TLS 1.2

https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15
 
You may need to enable TLS 1.2 for SQL Server communication if disabled.
What is the correct registry setting to enable TLS 1.2 for SQL Server communication? The correct registry settings are as follows:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2]
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client] "DisabledByDefault"=dword:00000000 "Enabled"=dword:00000001
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server] "DisabledByDefault"=dword:00000000 "Enabled"=dword:00000001 

See Also

Connecting to MS Access Database from MicroStation Connect

Other language sources

 Original Author:Leonard Jones