sa user on cluster node
Posted on 2004-10-22
I installed Cluster on windows2003EE.
I installed SQL Instances on the cluster.
Everything is OK until I am trying to change the agent user name and password from
Windows account to saprel user.
The problem starts when I m shuting down node1 ans all Instances move to node2
The SQL agent does starts and the error log shows : SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000].
When I startup the node1 and try to start the agent in node2 everything is OK.
From the log it shows that I am using user sa, when I am using user sarepl.