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
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.
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.