Connect to Azure SQL Server Database

Thu, 30 Oct 2014 21:57:19 GMT

I have a cloud server named QvTest that holds a SQL Server 2014 database. I have another cloud server named QVDBTest that contains a QlikView 11 dashboard. I'm trying to figure out how to structure the OLE DB connection string so that I can access tables in the database.

I have created a special script tab for my dashboard just to test connectivity. The machine I am connecting from (QVDBTest) has the Microsoft OLE DB Provider for SQL Server (SQLNCLI11).

According to ConnectionStrings.com, the general form of the connection string looks like this:

Provider=SQLNCLI11;Password=myPassword;User ID=[username]@[servername];
Initial Catalog=databasename;Data Source=tcp:[servername].database.windows.net;

I've tried a couple of variations to this, and I cannot connect to QVDBTest:

[Provider=SQLNCLI11;Password=MyPassword;User ID=[Account\MyUser]@[QVDBTest.cloudapp.net:50280];Initial Catalog=DataMart;Data Source=tcp:[QVDBTest].database.windows.net]

What am I missing from the connection string?

Thank you for your help.

topic Connect to Azure SQL Server Database in QlikView

Connect to Azure SQL Server Database