Remote SSAS Connection

Jul 25, 2011 at 10:07 PM

How About a Connection to a Remote SSAS?

Can we specify credentials to be used?

Coordinator
Jul 28, 2011 at 6: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?

Coordinator
Jul 28, 2011 at 10: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.

eg.

$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.