I have a client who has hardened their Servers. They have limited communication protocol to TLS 1.2. According to a MS SQL Server ODBC search, "ODBC Driver 11 for SQL Server" has been updated to be compatible with TLS 1.2. I have created a simple install program to figure out all of the settings and how to use the Driver throughout the install process. The issue I'm having is that I do not know where the connection string for the "SQL Database Browse" is located or how to set the ODBC driver and SQL Authorization setting in the connection string .
On the "SQLServerConnectionDlg" dialog, I have a "Test SQL Connection" button with the following setting. The test is always successful when I check "Trusted Connection (Windows Integrated authentication)".
SQL_AUTHORIZATION
UID=[USERNAME_PROP]; Pwd=[PASSWORD_PROP]
Condition: NOT SQL_TRUSTED_CONNECTION
SQL_AUTHORIZATION
Trusted_Connection=Yes;
Condition: SQL_TRUSTED_CONNECTION
SqlConnectionString
Driver=[\{]ODBC Driver 11 for SQL Server[\}];Server=[SERVER_PROP];[SQL_AUTHORIZATION]
When I execute the built-in Custom Actions "ShowDatabases", I get the ODBC Connection Timeout error message.
SQL Database Browse Settings
Server Name: {SERVER_PROP]
Trusted Connection (Windows integrated authentication): False
Username: [USERNAME_PROP]
Password: [PASSWORD_PROP]
Display the result into a Combobox control: True
ComboBox Property: DATABASE_PROP
Attached to an event
Dialog: SQLServerConnectionDlg
Control: BrowseDatabases