Unable to connect to MS SQL 2008R2 SSAS cube from client machine

HI,

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

Virat
0 ● 1 ● 1

Are you getting an error message? If so, can you post it?

May 25 '12 at 06:26 PM KenJ

Definitelly post more information like error message, information whether you are connecting to default or named instance. And first of all, check, that you have ports opne in the firewall.

May 28 '12 at 06:38 AM Pavel Pawlowski

(comments are locked)

1 answer:

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