Re: Resources not coming online

Its a domain account, but not a member of the Domain Admins or Administrators
groups (or schema\enterprise admins groups).

"Geoff N. Hiten" wrote:

Make sure you are not using a domain admin account as your SQL Service
account.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"kj2n" <kj2n@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:57F7B0A0-EC9C-4869-B64B-A9362C7C7135@xxxxxxxxxxxxxxxx
I have a new 2 node active\passive Windows 2003 R2 SP2 64bit, SQL 2005 SP2
(with latest patches) installed. When I failover from node1 to node2, the
SQL Server, SQL Server Aent and SQL Analysis services do not come online.
I
can not bring them online manually either. The services are stopped.
When I
go into the services applet and try to start them manually, I get a logon
error issue. I open the service, re-enter the password and am then able
to
start the services and bring the resources online. I can fail back to
node1
without issues. If I failover to node2 again, the same issue occurs.

If I reboot node1 and failover to node2, everything is fine (now that I
re-entered the services passwords). If I'm active on node2 and failover
to
node1 after the restart, I have the same issue. I have to re-enter the
service passwords on node1.

It seems that a restart does something to the service passwords for that
particular node. Any ideas?


.

Relevant Pages

  • Re: Applying SQL Service Packs
    ... You should reinstall the Service Pack to the cluster starting with the node that is NOT patched owning the instance. ... Node1 has been a stand-alone for one year, ... Node2 was built and added to the cluster, SQL Server installed to ...
    (microsoft.public.sqlserver.clustering)
  • Resources not coming online
    ... SQL Server, SQL Server Aent and SQL Analysis services do not come online. ... node1 after the restart, ... service passwords on node1. ...
    (microsoft.public.sqlserver.clustering)
  • Applying SQL Service Packs
    ... We have a 2-node SQL Server 2000 Cluster on Server 2003 Enterprise. ... Node1 has been a stand-alone for one year, ... Node2 was built and added to the cluster, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Resources not coming online
    ... When I failover from node1 to node2, ... SQL Server, SQL Server Aent and SQL Analysis services do not come online. ... If I failover to node2 again, ... service passwords on node1. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Resources not coming online
    ... Have you tried setting the password using the SQL Configuration tool? ... Microsoft SQL Server MVP ... If I reboot node1 and failover to node2, everything is fine (now that I ... service passwords on node1. ...
    (microsoft.public.sqlserver.clustering)
Loading