Connection strings for OLAP, Analysis Services
Providers for OLAP, Analysis Services
Community Forums
Find solutions and post questions regarding connection string related issues.
ADOMD.NET
Standard
Data Source=myServerAddress;Catalog=myDataBase;
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;
Authenticated Connection
This one authenticates the user but does not secure the communication.
Data Source=myServerAddress;Catalog=myDataBase;ProtectionLevel=Connect;
Unauthenticated Connection
This one provides no form of authentication.
Data Source=myServerAddress;Catalog=myDataBase;ProtectionLevel=None;
Microsoft OLE DB Provider for OLAP
Standard
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;
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.
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;
.NET Framework Data Provider for OLE DB
Type: .NET Framework Wrapper Class Library
Usage: System.Data.OleDb.OleDbConnection
Usage: System.Data.OleDb.OleDbConnection
Manufacturer: Microsoft
More info about this wrapper class library »
More info about this wrapper class library »
Bridging to OLE DB Provider for OLAP
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Provider=MSOLAP;Data Source=myServerAddress;Initial Catalog=myDataBase;
Selected Articles