Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-10-30 05:57 PM

Connect to Azure SQL Server Database

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.


1,310 Views
0 Likes
0 Replies