SQL Server Performance Forum – Threads Archive
cannot open connection to analysis server ‘servernJust 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?
Are you running AS service as local system account or for particular account.
It would be a worth trying if you set it for a particular user and not as local system account.
There is a windows user group called OLAP Administrators. Make sure that the account that runs the service is a member of this and I believe that your log on needs to be a member of it to register the server. Regards, Robert.