How to connect to Analysis Services (SSAS) from a different domain user
Posted Under: Analysis Services, How-To, Security, Tips
As all of us know that Microsoft SQL Server Analysis Services SSAS only allows users of the same domain or trusted domains and it does not allow users from any domain except from these two. So, if we want to connect from a machine which is not part of the domain then here is a small trick to do that but please note that this is just a temporary solution and is not recommended for production systems.
Suppose you are on a developer machine which is not part of the domain of SSAS you are logged in with the user name UserSSAS then create a user on the computer where SSAS instance is running with exactly the same user name and password and now try to connect. You will be able to connect. This is because the user will be authenticated on the Analysis Services computer by using the local user account with the matching credentials.
For the detailed discussion of connection issues of SSAS please check this article on microsoft site Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios
Reader Comments
I tried this and it did not work. I assume that the source domain name, followed by a slash, was not required (because the slash caused a conflict). Both users are set up identically, but I still get an error:
The logon attempt failed (Microsoft.AnalysisServices.AdmondClient)
Maybe it’s a local setting - here’s the deal:
I log onto workstationI in DomainA
I want to connect to AS in DomainB
I cannot do it from workstationI.
I can do it by remoting into another machine, workstationII, in DomainA, but workstationII uses a different IP subnet.
Listen guys, every time when i open your site - it’s very hard loading! So slow... (( Do something please! Fix this.
And i’m can’t understand - html are working here or not? Thanks.
Hi Biblio,
RSS link is on top right of the page. Please use it.
Namwar
If passthrough authentication doesn’t work or you don’t wanna use passthrough authentication then u can use HTTP Pump and allow users to connect to analysis services using basic authentication.
Ref:
http://technet.microsoft.com/en-us/library/cc917712.aspx
Thanks a lot . This helped me