x

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.
more ▼

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

Virat gravatar image

Virat
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 oldest

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

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x171

asked: May 25, 2012 at 01:29 PM

Seen: 864 times

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