July 7, 2005 at 10:51 am
i'm new to clustering and wondering what's going on.
one of my clusters is going back and forth between nodes, and not staying on either.
i'm thinking it's the startup account.
how do i change the startup account for my SQL cluster?
Thanks
July 7, 2005 at 10:59 am
July 7, 2005 at 11:41 am
What does the error log for SQL Server indicate? Anything in the system or application event logs? Usually if they're boucing there'd be something in the Windows logs as to an error occuring.
K. Brian Kelley
@kbriankelley
July 7, 2005 at 12:04 pm
our mssqlserver service will not come up, even though we have verified that the password is correct.
it will 'bring online' and we are temporarily able to connect, but then fails.
July 7, 2005 at 12:09 pm
Do you have any group policies that make changes to settings like "Log on as a service" or "Act as part of the operating system" or "Log on as a batch job" that would effect the cluster? Also, are you seeing any errors in any of the event logs or in the SQL Server error log itself?
K. Brian Kelley
@kbriankelley
July 7, 2005 at 12:21 pm
ok think i've found the problem.
builtin administrators was disabled.
wasn't aware this was needed to run the cluster.
my fault.
July 7, 2005 at 12:26 pm
i disabled builtin administrators last week, but this problem didn't happen until now, why is that?
i understand that the domain account wasn't able to login, when i disabled the builtin admin.
thanks for the help
July 7, 2005 at 12:53 pm
BUILTIN\Administrators isn't needed, but before it is removed the SQL Server service account and the Cluster service account both need to be added and given sysadmin rights. More here:
SQL Server Security: Security Admins
K. Brian Kelley
@kbriankelley
July 7, 2005 at 1:08 pm
I can't believe i did that without checking.
Thanks
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply