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


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.

more ▼

asked May 25, 2012 at 01:29 PM in Default

avatar image

0 1 1 1

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

May 25, 2012 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, 2012 at 06:38 AM Pavel Pawlowski
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered May 28, 2012 at 12:06 PM

avatar image

Usman Butt
13.9k 6 13 21

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 25, 2012 at 01:29 PM

Seen: 1127 times

Last Updated: May 28, 2012 at 12:06 PM

Copyright 2016 Redgate Software. Privacy Policy