Solved

cluster error: causing the failure of the failover

Posted on 2009-05-07
3
319 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
3 Comments
 
LVL 2

Accepted Solution

by:
Miele102 earned 500 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now