Run script on Azure SQL

[mikomada]

Hello,

I am trying to run sql script on Azure SQL db.  I have selected "Microsoft Windows Azure" as target database server, however during the installation I get the following error:

Error 27502. Could not connect to Microsoft Windows Azure 'xxx.database.windows.net'. [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)

I have the driver installed though. 

Also, is Active Directory Integrated authentication method supported by InstallShield?

[Jenifer · Accepted solution]

Hi @mikomada ,

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.

You can get more details from:https://helpnet.flexerasoftware.com/installshield23helplib/helplibrary/ConnectToSQLAzure.htm?

Thanks,

Jenifer

[mikomada]

I've already had the driver installed in version 12. When I have installed version 10 it worked.

I think it should work with other versions as well.
Anyway, thanks for help.