Wednesday, 8 June 2016

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"
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.