AdvancedInstaller ODBC Connect: Timeout Exceeded

When using AdvancedInstaller you may see the following error
ODBC Connect: Timeout Exceeded


...when you are using the SQL Server ODBC driver and TLS 1.0 has been disabled.

You can test this using the following PowerShell Script (modify the connection string as you need).




Write-Host "Connecting..."
$connection = New-Object System.Data.Odbc.OdbcConnection
$connection.ConnectionString = "Driver={SQL Server};Server=localhost\SQLExpress; Trusted_Connection=yes; Database=dbXIAConfiguration"
$connection.Open()
$connection.Close()
Write-Host "Connected"


If this is the same error you will see the following

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

NOTE: The SSL Security Error
Check the following registry key and ensure that is set to 1

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client\Enabled

NOTE: TLS 1.0 may have been disabled due to the security policy of your organisation.



Comments

Post a Comment

Popular posts from this blog

Windows Server 2016, 2019, 2022, Windows 10 and Windows 11: Date and time "Some settings are managed by your organization".

TFTPD32 or TFTPD64 reports Bind error 10013 An attempt was made to access a socket in a way forbidden by its access permissions.

Enable function lock for F1-F12 on HP ZBook mobile workstations