Hi

I have a two node cluster with SQL2000 SP3. When the node1 fails over to
node2, the SQL Server Agent fails. The log file says "Login Failed for user
'sa'" I don't understand how the SA account can fail on node2 and not on
node1. Can anyone shed some light on this and possibly how to resolve the
issue.

Thank You

Marc

What security account context is the SQL Agent running under? Is it a domain account and does it have adequate permissions/rights on both nodes?

Hi Stephen

SQL security is set for "SQL Server and Windows" and the service account is
in the Domain Admins group. Same service account is used for both nodes.

Regards

Marc

"Stephen Strong" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Is the SQL Server Agent startup account a member of the local admin group
on both nodes. If you are using SQL Server authentication for SQL Server
Agent to connect to SQL Server then the SQL Server Agent startup account
has to be a local Admin.

You can check the SQL Agent connection properties by right clicking on SQL
Server Agent - Properties - Connection and see how the connection to SQL
Server is set up.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Thanks Guys

As it turns out, one of our programmers changed the authentication method to
Windows rather than SQL. I changed it back and all is well.

Regards

Marc


"Marc" <Marc (AT) nospam (DOT) com> wrote