Resources not coming online

#41

Thank you for your help. Darn group policies. Default Domain policy had a
"Logon as a Service" setting enforced. The new SQL Service accounts were
granted that right and voila everything is working.

Thank you again for your quick response!

"Geoff N. Hiten" wrote:

Quote:

I have seen this when a Service Pack install did not complete successfully
but I figure you would have noticed that.

Are there any messages in the Application or System log?

Have you tried setting the password using the SQL Configuration tool?

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

"kj2n" <kj2n (AT) discussions (DOT) microsoft.com> wrote in message
news:9AB6F6CA-0891-4E11-B6DD-1A270AD90746 (AT) microsoft (DOT) com...
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 (AT) discussions (DOT) microsoft.com> wrote in message
news:57F7B0A0-EC9C-4869-B64B-A9362C7C7135 (AT) microsoft (DOT) com...
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?

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

Resources not coming online

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

Re: Resources not coming online - 09-29-2008 , 09:26 AM