dbTalk Databases Forums  

Connecting to a remote Analysis Server (MSAS) 2000

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


Discuss Connecting to a remote Analysis Server (MSAS) 2000 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jerry B
 
Posts: n/a

Default Connecting to a remote Analysis Server (MSAS) 2000 - 08-16-2006 , 04:52 PM






Is there anything special that has to be set up in order to register a
remote MSAS server? When I installed Analysis Services, my Analysis Manager
automatically registered the local MSAS Server (and also added the Foodmart
Data Source).

Now I need to connect the MSAS server that is on the same box as MS Project
Server (to create CUBES for MSP Server Portfolio Analyzer). I tried
specifying the name of the box (since MSAS 2000 doesn't use named instances).
I also entered the IP address of the remote box. Neither works.

Do certain permissions need to be added to the (Win 2003) box that the
server is on for me to connect? Is there some kind of Authentication involved
(no userid or password was asked for -- only the name of the remote MSAS
server).

Thanks

Reply With Quote
  #2  
Old   
tsachin@gmail.com
 
Posts: n/a

Default Re: Connecting to a remote Analysis Server (MSAS) 2000 - 08-17-2006 , 05:57 PM






Hey,

Make sure that your user belongs to the OLAP Administrators
group on the server you are trying to connect to


Jerry B wrote:
Quote:
Is there anything special that has to be set up in order to register a
remote MSAS server? When I installed Analysis Services, my Analysis Manager
automatically registered the local MSAS Server (and also added the Foodmart
Data Source).

Now I need to connect the MSAS server that is on the same box as MS Project
Server (to create CUBES for MSP Server Portfolio Analyzer). I tried
specifying the name of the box (since MSAS 2000 doesn't use named instances).
I also entered the IP address of the remote box. Neither works.

Do certain permissions need to be added to the (Win 2003) box that the
server is on for me to connect? Is there some kind of Authentication involved
(no userid or password was asked for -- only the name of the remote MSAS
server).

Thanks


Reply With Quote
  #3  
Old   
Jerry B
 
Posts: n/a

Default Re: Connecting to a remote Analysis Server (MSAS) 2000 - 08-17-2006 , 06:42 PM



I am having the tech manager at my client look into this.


"tsachin (AT) gmail (DOT) com" wrote:

Quote:
Hey,

Make sure that your user belongs to the OLAP Administrators
group on the server you are trying to connect to


Jerry B wrote:
Is there anything special that has to be set up in order to register a
remote MSAS server? When I installed Analysis Services, my Analysis Manager
automatically registered the local MSAS Server (and also added the Foodmart
Data Source).

Now I need to connect the MSAS server that is on the same box as MS Project
Server (to create CUBES for MSP Server Portfolio Analyzer). I tried
specifying the name of the box (since MSAS 2000 doesn't use named instances).
I also entered the IP address of the remote box. Neither works.

Do certain permissions need to be added to the (Win 2003) box that the
server is on for me to connect? Is there some kind of Authentication involved
(no userid or password was asked for -- only the name of the remote MSAS
server).

Thanks



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.