OLAP, Analysis Services connection strings

ADOMD.NET

Problems connecting?
Get answer in the OLAP, Analysis Services Q & A forum

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.

  • 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;
  • Unencrypted and uncompressed HTTP for tracing

    Provider=MSOLAP;Data Source=http://serverName/;Initial Catalog=myDataBase;
    User Id
    =domain\user;Password=myPassword;Protection Level=connect;
    Transport Compression
    =None;Protocol Format=XML;

.NET Framework Data Provider for OLE DB

  • Use an OLE DB provider from .NET

    Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

    See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.

Q&Aask question »

Articlesread all »

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.