Thursday, February 16, 2012

Analysis Services will not start after failover

On Thursday, everything was fine. On Friday my second virtual instance
of SQL Server was now on Node 2 for some reason. I tried to move it
back to Node 1 and it failed and continued to go back to Node 2. I
looked for errors in the SQL Error log and the system error logs and no
information why the system failed in the first place.
Now I was able to get the second instance of SQL Server back over to
Node 1 but the Analysis Services and the MSOlap resources along with
one additional resource will not come back on either Node.
When Analysis Services was first installed on the cluster (yes I know
it isn't cluster aware), I failed over the node and Analysis Services
worked fine.
Anyone have any ideas? Luckily this is the test system, but until I
get this figured out, I won't even think about production.
If you have absolutely no errors, then you'll have to open a support case
with PSS. I couldn't even begin to guess what might be wrong without an
error message to point to something
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Benny" <wildfire77@.peoplepc.com> wrote in message
news:1144166302.904251.252350@.u72g2000cwu.googlegr oups.com...
> On Thursday, everything was fine. On Friday my second virtual instance
> of SQL Server was now on Node 2 for some reason. I tried to move it
> back to Node 1 and it failed and continued to go back to Node 2. I
> looked for errors in the SQL Error log and the system error logs and no
> information why the system failed in the first place.
> Now I was able to get the second instance of SQL Server back over to
> Node 1 but the Analysis Services and the MSOlap resources along with
> one additional resource will not come back on either Node.
> When Analysis Services was first installed on the cluster (yes I know
> it isn't cluster aware), I failed over the node and Analysis Services
> worked fine.
> Anyone have any ideas? Luckily this is the test system, but until I
> get this figured out, I won't even think about production.
>

No comments:

Post a Comment