Adding a New SQL Connection

InstallShield 2019

Project • This information applies to the following project types:

In the SQL Scripts view, scripts are organized by connection, since no script can run on a server until a connection has been established. Therefore, before you can add any SQL scripts to your project, you must first create a SQL connection.

To create a new SQL connection:

InstallShield adds a new connection in the explorer. Use the tabs in the right pane to configure the settings that are associated with this connection.

Note • The SQLLogin and SQLBrowse dialogs let end users use alias names for connecting and browsing to SQL Server databases.

Microsoft has released a new OLE DB provider called Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL). Going forwar, the new provider will be updated with the most recent server features. This provider also supports TLS 1.2 only environments.

InstallShield 2019 R3 and later now uses MSOLEDBSQL as the default provider for all new SQL Server connections. This can be changed by choosing different SQL Driver from 'Choose a Driver for Database Server' drop down present in the Requirements tab.

Important • Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is included as a prerequisite in InstallShield 2019 R3 and later.

For more information, see Choose SQL Driver for Database Server in Requirements Tab.

See Also

Requirements for Connecting to Instances of SQL Server Express LocalDB

Overriding the Default TCP/IP Network Library with a Different Protocol for a SQL Server Database

SQL Scripts View

Open topic with navigation