This project has moved and is read-only. For the latest updates, please go here.

Remote SSAS Connection

Jul 25, 2011 at 11:07 PM

How About a Connection to a Remote SSAS?

Can we specify credentials to be used?

Jul 28, 2011 at 7:17 AM

You can connect to remote SSAS servers fine using windows credentials. But SSAS itself does not support passing credentials unless you are using HTTP authentication - Is that what you are talking about - Passing credentials when connecting over HTTP?

Jul 28, 2011 at 11:28 AM

I just did a quick test with http connectivity and you can pass the user name and password in the cmdlets like get-asserver by appending them after the server name.


$svr = get-asserver "http://localhost/olap/msmdpump.dll;User ID=<UserName>;Password=<Password>"

However their appears to be some issue with doing this using the provider to create a PSDrive so I'll have to have a look at that.