sa user on cluster node

Hi

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 :[298] 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.

Please advice

Thanks

NirE
infogate85Asked:
Who is Participating?
 
appopConnect With a Mentor Commented:
The normal reason for this problem is simply down to the way the service password was changed. In a clustered environment you must connect directly to each node in the the cluster and and open the services applet from control panel and ensure that these are both set to use the same account.
0
All Courses

From novice to tech pro — start learning today.