Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

cluster error: causing the failure of the failover

Posted on 2009-05-07
3
Medium Priority
?
327 Views
Last Modified: 2012-08-13
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
Comment
Question by:krishna_harik
2 Comments
 
LVL 2

Accepted Solution

by:
Miele102 earned 1500 total points
ID: 24323779
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
 

Author Closing Comment

by:krishna_harik
ID: 31578899
thanks for your response and we are analysing the issue, your reply may help us to find the solution.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question