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.

image

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

image

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

Solution: 

image

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

And it will just do fine ! Smile

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: