Post reply

cannot open connection to analysis server ''servername''

  • February 20, 2006 at 11:42 am

    #167115

     

    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

  • February 20, 2006 at 3:56 pm

    #622131

    Check On which node is the service active and try starting from there..

    And also how are you trying to start the service? use cluster administrator or the sql service manager..

    -Krishnan

  • February 21, 2006 at 7:11 am

    #622261

    thanks for the response. Infact we at SP 4 at this point. The error message that I get in the event viewer when starting mssqlserverolapservice service is as follows:

     

    Cannot change the server's start directory to T:\Program Files\Microsoft Analysis Services\Data

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

     

    I wonder why is it trying to look at T drive? when I look at cluster resources in cluster admin T drive is mapped as SQL-AS Cluster Group Disk. however i dont see a T drive in windows explorer. Any thoughts?

    I tried both ways.. i.e. used the failover method to the other node in the cluster admin...as well as the started it from the service manager.

  • February 21, 2006 at 9:10 am

    #622334

    Yes its active-passive cluster. I finally got the mssqlserverolapservice service to run. however when I try to register the server within analysis manager I get same error message

     

    cannot open connection to analysis server ''servername''

    mssqlserverolapservice is running under local system account. where as SQLServer is running under a different domain user account.

    whats happening?

  • February 22, 2006 at 2:50 am

    #622558

    Your SQL server has a virtual name, use that, not the machine names.

  • February 22, 2006 at 7:09 am

    #622605

    Well I am little confused. Perhaps someone can help me understand. I have a two node cluster. Node1 = dbacl01 node2=dbacl02 and sql server instance name = 006-pm2-dbasql .

    I am unable to register the sql server instance 006-pm2-dbasql in the analysis manager. however while I was logged into active cluster node dbacl01 via remote desktop i was able to register dbacl01 in the analysis manager. i am confused how can I register dbacl01 in the analysis manager and not the actual sql server instance 006-pm2-dbasql? can someone help? i am not able to do a query analyzer session to dbacl01 so how come it got registered in analysis manager?

  • February 23, 2006 at 2:45 am

    #622839

    Hmm, open up Cluster Resource Manager and check the Analysis Services appears as a clustered resource.

    Check you get DNS on both nodes and your PC for 006-pm2-dbasql.

    They key stage at installation is when you select the Analysis Services component, that you then "Create an Analysis Server failover cluster". I'm not sure this can be done incorrectly, but it's worth checking you went through the install properly as linked:

    http://support.microsoft.com/?kbid=910230

    Good luck.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply