Connection strings Examples for OLAP and Analysis Services

Connection strings Examples for OLAP and Analysis Services

.NET Data Provider for OLE DB

This is a .NET wrapper class library from Microsoft. The usage for this provider is System.Data.OleDb.OleDbConnection.

Standard Security:

Provider=MSOLAP;Data Source=yourServerAddress;Initial Catalog=yourDataBase;

ADOMD.NET

This is a .NET class library from Microsoft.

Standard Security:

Data Source=yourServerAddress;Catalog=yourDataBase;

Encrypted Connection:

Data Source=yourServerAddress;Catalog=yourDataBase;ProtectionLevel=PktPrivacy;

Signed Connection:

Data Source=yourServerAddress;Catalog=yourDataBase;ProtectionLevel=PktIntegrity;

Note: No conent are modified in the communication.

Authenticated Connection:

Provider=MSIDXS;Data source=YourCatalog;Locale Identifier=1033;

Note: user is authenticated but the commication is not secured.

Unauthenticated Connection:

Data Source=yourServerAddress;Catalog=yourDataBase;ProtectionLevel=None;

Note: communication is not secured.

Microsoft OLE DB Provider for OLAP

This is an OLE DB Provider from Microsoft. The usage for this provider is Provider=MSOLAP.

Standard Security:

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

Over HTTP:

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

Over Secure HTTP:

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

Using Integrated Security:

Provider=MSOLAP;Integrated Security=SSPI;Persist Security Info=False;Data Source=https://serverName/;Initial Catalog=myDataBase;

Integrated Security with Kerberos:

Provider=MSOLAP;Integrated Security=SSPI;SSPI=Kerberos;Persist Security Info=False;Data Source=https://serverName/;Initial Catalog=myDataBase;