• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 545
  • Last Modified:

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
0
infogate85
Asked:
infogate85
1 Solution
 
appopCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now