I am unable to Connect to SSAS cube which was developed on Server machine(SQL Server 2008 R2) from my desktop through SSMS (SQL 2008 Developer Edition).
Please help me in this regard.Thanks, Virat.
asked May 25 '12 at 01:29 PM in Default
In addition to the said above, you must know that by default Analysis Services only supports Windows Authentication. If you are in a situation where you are logged into a domain and your desktop machine is outside the domain OR you are not logged into the system with an authenticated user, this will not work and HTTP authentication is your only choice.However, if there is no domain, then you can create users with same name/password on the server and desktop machine to make it work.
answered May 28 '12 at 12:06 PM