SSAS 2008 – Remote Server Access (Insecure, Irresponsable way) – Just for Tests

If you aren’t member of a domain, then you can’t access a remote SSAS server, since the only authentication method available for it, is Win method.

However, I recently found a way, to bypass this security measure. I must say is for sure the worst solution in terms of security, but if you need to make a few tests inside your LAN, then maybe there wouldn’t harm your server.

So, the trick is dumb and simple, disable the authentication on your SSAS server (yes I know what you must be thinking, oh my god, that sucks!). But a least I had told you that before .

How you can disable the authentication ?. Simply, Open your SSMS , right click on the server -> Properties ->change the value of Security\RequireClient Authentication to false.

That’s it, but remember to turn this setting to true  after testing the remote server, otherwise the server’s security will be compromised.