dbTalk Databases Forums  

Can't connect to a remote Analysis Server & use migration Widzard

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Can't connect to a remote Analysis Server & use migration Widzard in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
valerie Uzan
 
Posts: n/a

Default Can't connect to a remote Analysis Server & use migration Widzard - 10-16-2005 , 03:38 AM






I installed Sql Server - Analysis Services 2005 (sept).

It works fine but when I try to connect to an Analysis Server, I can see
only server on my local machine and can't connect to an Analysis server
installed on a remote machine.

In side of this, I tried to use the migration wizard but it can't connect to
my server source that is located on another machine.

How to connect to my remote Analyses server and do my migration?

Thanks for your help


Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Can't connect to a remote Analysis Server & use migration Widzard - 10-17-2005 , 01:19 AM






Does the service account that you specified when you install AS2K5 has the
network and databae rights to connect to the remote server and access the
data as an OLAP Administrator, i.e. did you specify a domain account with
enough rights?
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"valerie Uzan" <valerie Uzan (AT) discussions (DOT) microsoft.com> wrote

Quote:
I installed Sql Server - Analysis Services 2005 (sept).

It works fine but when I try to connect to an Analysis Server, I can see
only server on my local machine and can't connect to an Analysis server
installed on a remote machine.

In side of this, I tried to use the migration wizard but it can't connect
to
my server source that is located on another machine.

How to connect to my remote Analyses server and do my migration?

Thanks for your help




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.