Over HTTP using MSOLAP

Connection string

This Microsoft OLE DB Provider for OLAP connection string can be used for connections to OLAP, Analysis Services.

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.