MS SQL – SSAS Connecting to Analysis Services in Another Domain

There are several tools available on the next to query an SSAS OLAP instance using MDX queries.

But most of the time you have the OLEDB drivers on your machine.


But some tools lack the authentication mechanism to poke into an OLAP cube that is not in your domain.

Like this MDX Query generation for QlikView


It allows you to connect but you can’t send across any authentication to connect remotely.



runas.exe /user:YourDomain\User /netonly “C:\Program Files (x86)\MDX Query Generator for Qlikview\QlikviewMDX.exe”

And it will just do fine ! Smile

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: