Generic service 'Analysis Services (TEST1)' could not be brought online (with error '1060') during an attempt to open the service. Possible causes include: the service is either not installed or the specified service name is invalid.

Question

Hi,

We have a cluster with 2 nodes. Everything works fine in Node1. When I try to failover TEST1 database to Node-2 it fails with this message.

Generic service 'Analysis Services (TEST1)' could not be brought online (with error '1060') during an attempt to open the service.  Possible causes include: the service is either not installed or the specified service name is invalid.

Any help is much appreciated.

Thanks

Answer 1

Hello,

The error message is pretty straight forward, it's saying either the service isn't installed or it's not installed as the same service on that node. Did you install analysis services on the second node (from the error it seems like it isn't)?

---

Sean Gallardy | Blog | Twitter

Answer 2

Hi,

Thanks for the reply. I did not install any services separately in Node-2. I followed the install instructions and added Node-2 after installing SQL Server 2012 in Node-1.

Does these services need to be installed separately in Node-2 too? Can you direct me to the install instructions?

Thanks

Answer 3

If you added node 2 (using add-node in the SQL Server setup) but didn't choose to install analysis services with it at the time on the other node, this is what is causing the problem.

Add a node again and choose to install the analysis services.

---

Sean Gallardy | Blog | Twitter