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

cluster error: causing the failure of the failover

We had a 3 node cluster environment, in which we are facing one problem like we have Serve1, Server2 and Server3 (nodes).
We are facing some issues with our existing cluster environment, the sql instance which running in Server3 node is not failing over Server2 node, sql services are failed to come online,  same is failing over to Server1 node success and all the sql services are coming online.

Cluster instance running as
Server1 --- failing over to Server2 and Server3.
Server2 --- failing over to Server3 and Server1.
Server3   failing over to Server1 but not to Server2.


Looking into the event viewer--> systemlog in server2, i captured the error that was causing the failure of the failover.
here is the error

Error1: (Sytemlog)
1. Service Control Manager - server(2)
The SQL Server (instance name) service failed to start due to the following error:
The service did not start due to a logon failure.

Error2:
2. Service Control Manager - server(2)
The MSSQLserver3 service was unable to log on as sqladmin with the currently configured password due to the following error:
Logon failure: unknown user name or bad password.

To ensure that the service is configured properly, use the Services snap-in in Microsoft Management Console (MMC).

Is the above error related due to AUTHENTICATION Problem?  please, help me in knowing the root cause.

0
krishna_harik
Asked:
krishna_harik
1 Solution
 
Miele102Commented:
Hi,
As i read your question it is quiet sure that a authentification problem.
It seem that the services are running under a account and the name or password could not be verified.
Check if al settings by services (logon) are the same as by the other nodes.
0
 
krishna_harikAuthor Commented:
thanks for your response and we are analysing the issue, your reply may help us to find the solution.
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

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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