Connecting to a Microsoft Windows Azure Database Server and Running SQL Scripts

InstallShield 2015

Project: This information applies to the following project types:

Basic MSI
InstallScript
InstallScript MSI

Target System Requirements for Connecting to a Microsoft Windows Azure SQL Database Server

Connecting to a Microsoft Windows Azure SQL database server requires the SQL Server Native Client 10.0 ODBC driver on target system that are running the installation. To ensure that this driver is available on target systems, you can include the InstallShield prerequisite for Microsoft SQL Server 2008 Native Client 10.00.2531 in your project.

To include the Microsoft SQL Server 2008 Native Client 10.00.2531 prerequisite in your project:

1. For Basic MSI and InstallScript MSI projects: In the View List under Application Data, click Redistributables.

For InstallScript projects: In the View List under Application Data, click Prerequisites.

2. In the list of redistributables, select the appropriate Microsoft SQL Server 2008 Native Client 10.00.2531 check box or check boxes, depending on whether the architecture of target systems is 32 bit or 64 bit.

The InstallShield prerequisite is launched only if the conditions that are defined in the InstallShield prerequisite file (.prq) are met. To see the list of conditions, click the SQL Server Native Client prerequisite in the Redistributables view or the Prerequisites view, and then review the details that are listed in the details pane on the right. You can hide or show the details pane by clicking the Show Details button in these views.

Specifying the User Name for the Windows Azure SQL Database Connection at Run-Time

If you use the SQLLogin dialog in your installation and your installation is targeting a Windows Azure SQL database, end users should use the following format to enter a string in the Login ID box on the SQLLogin dialog:

DatabaseUserName@ServerName

Following is an example:

MyUserName@wbzdh64drd

See Also