Configure MS-SQL Server Connection

ImportantThe following article uses options that are available starting with the Enterprise edition and project type.

This tutorial uses the predefined SQLConnectionDlg dialog and all the settings will be collected during install time and then passed to the installer. In order to do this public properties will be used.

1. Create project

Launch Advanced Installer, select Enterprise and press the [ Create Project ] button.

Start Page

2. Add SQL connection dialog

Dialogs Page Go to Dialogs Page and select FolderDlg dialog. Select “Add Dialog” toolbar option or “Add Dialog...” context menu option.

The Add Dialog dialog will appear. Select SQLConnectionDlg from the list and press "OK". The new dialog will be added in the chain after the FolderDlg dialog.

In the SQLConnectionDlg dialog select the "ODBC Resource" static text control and from the Properties pane located in the right side, set the Visible attribute to False.

Repeat the same procedure for the edit box control associated with "ODBC Resource".

3. Create the SQL connection

Navigate to SQL Databases Page, Database server and select “New Connection -> Predefined” option from the toolbar or context menu.

NoteThis will change the installation type to "Per-machine only".

Rename the connection to something meaningful. Using the "SQL Connection" properties pane from the right side, write the following settings:

Parameter nameValue
Connection TypeMicrosoft SQL Server / MSDE
Connection ModeODBC Driver
ODBC DriverSQL Server
Server[SERVER_PROP]
Portautomatic
Username[USERNAME_PROP]
Use a property to set password[PASSWORD_PROP]
Database[DATABASE_PROP]

Since we are going to use this connection with Microsoft SQL Server we will not use a property to set the "ODBC Driver" parameter and we will hard-code it instead.

Microsoft SQL Server settings

Add all the necessary resources like files and folders to the project, build and run it.

4. Test the installation package

It is wise to test if the package is correctly connecting to your SQL Server before giving it to your customers.

Note The Test SQL Connection How To article shows the steps needed to take in order to test your SQL connection.

Once the installation package is running navigate to the "SQL Database" dialog and enter the following information:

  • Server
  • The name of the SQL Server. Use the Computer-name format to specify a default instance, or (local) when the server is hosted on the local machine, otherwise for a named instance use the following format: Computer-name\Instance-name.
  • Port
  • The port used by the SQL Server. By default, Microsoft SQL Server uses the 1433 port.
  • Database
  • The name of the database to which the install package will connect to.
  • Username
  • The username under which the connection will be initiated. This user must have privileges to connect to the SQL Server. By default, Microsoft SQL Server comes with the sa user (System Administrator).
  • Password
  • The password associated with the user. For the sa user this password is set during the SQL Server installation.

SQL connection settings

5. See also

MySQL Server Connection