OLAP, Analysis Services connection strings

ADOMD.NET

Encrypted Connection

This one authenticates the user and encrypts the communication. This is the highest level of security.

Data Source=myServerAddress;Catalog=myDataBase;ProtectionLevel=PktPrivacy;

Signed Connection

This one authenticates the user and and prevents the content in the communication to be modified.

Data Source=myServerAddress;Catalog=myDataBase;ProtectionLevel=PktIntegrity;

Microsoft OLE DB Provider for OLAP

Standard

Provider=MSOLAP;Data Source=myServerAddress;Initial Catalog=myDataBase;

If you have more then one OLEDB for OLAP provider installed you may need to specify the version of the provider in the connection string, MSOLAP.1 for MSAS 7.0, MSOLAP.2 for MSAS 2000, MSOLAP.3 for MSAS 2005, MSOLAP.4 for MSAS 2008. Just specifying MSOLAP as Provider uses the latest version of OLE DB for OLAP installed on the system.

Over HTTP

Provider=MSOLAP;Data Source=http://serverName/;Initial Catalog=myDataBase;User Id=domain\user;Password=myPassword;

The username and password will be sent in clear text over the network using this connection string. If this is an issue, consider using the Secure HTTP (HTTPS) connection string instead.