Connecting to SQL Server in a cloud

[#1]

Dear All,

I got a URL, user & password to connect to SQL Server in the cloud.

Does anyone know how I can define the connection?

Thanks in advance!

[Gysbert_Wassenaar]

Perhaps this link helps:

SQL Server Native Client 10.0 OLE DB Provider Connection String Samples - ConnectionStrings.com

If you're trying to connect to SQL Azure instead of SQL Server you can try defining an odbc connection in the odbc manager instead of trying oledb:

General Guidelines and Limitations (Windows Azure SQL Database)

[#3]

Hi,

Should I create a connection string and use it in the script itself?

Thanks!

[#4 · Accepted solution]

Hi,

I had to create an ODBC connection with the URL as the SQL server name.

Afterwards, I could connect with QlikView selecting it from the available ODBC connections list.