dbTalk Databases Forums  

cannot open connection to analysis server 'servername'

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


Discuss cannot open connection to analysis server 'servername' in the microsoft.public.sqlserver.olap forum.



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

Default cannot open connection to analysis server 'servername' - 02-20-2006 , 12:55 PM






Just installed analysis services on a cluster. however when I log on to
analysis manager and try to perform a registration i get following
message

errors occurred while connecting to 'servername'
cannot open connection to analysis server 'servername'

i am trying it on the clustered node itself. also tried from a client
but doesnt work. I thought it might be because MSQLServerOlapService is
not running. When I try to bring up the service I get the following
error message

'The MSSQLServerOlapService' service on local computer started and then
stopped. Some Services stop automatically if you do not have any work
to do, for example performance logs and alerts service'

any idea whats happening here?
thanks


Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: cannot open connection to analysis server 'servername' - 02-21-2006 , 06:18 AM






What sort of cluster are you talking about?

Load Balanced or Failover?
Active-Active or Active-Passive?

Have you seen the knowledge base article at
http://support.microsoft.com/?kbid=308023 which runs through all the
steps required to set up AS2k on a failover cluster?

Have you checked the event log to see if there are any errors in it
indicating why the MsOlapService may have stopped?

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1140461736.350846.76080 (AT) g14g2000cwa (DOT) googlegroups.com>,
shahab.nasir (AT) gmail (DOT) com says...
Quote:
Just installed analysis services on a cluster. however when I log on to
analysis manager and try to perform a registration i get following
message

errors occurred while connecting to 'servername'
cannot open connection to analysis server 'servername'

i am trying it on the clustered node itself. also tried from a client
but doesnt work. I thought it might be because MSQLServerOlapService is
not running. When I try to bring up the service I get the following
error message

'The MSSQLServerOlapService' service on local computer started and then
stopped. Some Services stop automatically if you do not have any work
to do, for example performance logs and alerts service'

any idea whats happening here?
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.