Cluster service won't start on Passive Node after reboot

#51

done all the checks, cluster still won't start.

Thanks for the help but I've just opened a case with MS Support to fix it

cheers
--
-- cranfield, DBA

"GPage" wrote:

Quote:

Nm about the cluster account being a local one, had a brain fart there has to
be a domain account. Make sure that it's in the local admin group though.

"GPage" wrote:

Is the cluster service running under a domain account or a local/system
account? If it's a system account then I would change it to a domain account
and give that account admin on both machines. Also is the SQL server service
account in the administrators group? If not put it there. Then you'll know if
it's a permissions issue. If it is then you can troubleshoot what permissions
it has and what it needs. I'll give ya a list in a bit once I look it up,
don't have it off the top of my head.

"Cranfield" wrote:

Hello

Thanks for the that. That seems to have sorted out the DCOM errors. Cluster
will still not start. When attempting to start through Cluster Admin I get
the following error boxes:

Could not start the Cluster Service on 'xxx'
Error 1067: The Process terminated unexpectedly

An error occurred attemting to start the Cluster Service on node 'xxx'
The Process terminated unexpectedly.
Error ID: -2147023829 (8007042b).

System event log:
Cluster service node initialization failed with error 2147746132.

The Cluster Service service terminated unexpectedly. It has done this 82
time(s). The following corrective action will be taken in 960000
milliseconds: Restart the service.

Could this still be some kind of permissions issue? I notice that on working
node I can view the Component Services\COM+ Applications node but on broken
node I get this error:

Error code 80110823 - The specified user cannot write to the system registry.

Perhaps its time to log a MS support call.

--
-- cranfield, DBA

"GPage" wrote:

First make sure the WMI service is running.

If it's running then open up component services on the box under
administrative tools, and expand the DCOM config. Go to the entry for
"Microsoft WMI Provider Subsystem Host" right click and select properties.
Click on the security tab. Look at the Launch and Activiation settings. If
they are set to customize click Edit and add the Network Service account
there. If use default is checked then click customize and edit then add in
the administrators group, local system, network service, interactive, and
system. Then you should be good to go.

"Cranfield" wrote:

Hello

After a reboot (following an SSIS install) the cluster service won't start
on my passive node. I see this error in the system log:

Cluster service node initialization failed with error 2147746132

.. and lots of these errors:

The machine-default permission settings do not grant Local Activation
permission for the COM Server application with CLSID
{73E709EA-5D93-4B2E-BBB0-99B7938DA9E4}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
permission can be modified using the Component Services administrative tool.

any help appreciated.
thanks
--
-- cranfield, DBA

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Cluster service won't start on Passive Node after reboot

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

RE: Cluster service won't start on Passive Node after reboot - 10-09-2008 , 11:17 AM