February 29, 2016 at 10:09 am
SQL server analysis services changes to Manual(From Automatic) whenever Windows patching is applied.
Its clustered server.
Can someone help me with this issue.
thank you,
Ruchitha
March 2, 2016 at 2:53 am
Clustering and SSAS can be a minefield.
That said, you have not told us any really relevant information; SQL Server version/edition, Operating system, type of clustering, which node this is happening on etc. so it's difficult to diagnose your exact problem. I *think* that in SQL versions prior to 2012, SSAS is not cluster aware, so this may be the cause.
Have a read of this: https://msdn.microsoft.com/en-us/library/dn736073.aspx
March 2, 2016 at 10:08 am
Microsoft SQL server 2012 Enterprise Edition
Operating System: Microsoft windows 2012 R2
Windows cluster.
THE SSAS Service changes to Manual on the Active node.
Thank you
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply