Solved

SQL Server 2008 Cluster in Failed state

Posted on 2013-11-07
5
767 Views
Last Modified: 2013-11-11
Hi folks,

after doing a SAN disk migration on our Cluster SQL 2008 Servers, we had an issue with the MSDTC service. Sadly and stupidly, I deleted it and recreate it.

Now the MSDTC goes up properly but SQL Server 2008 appears in Failed state when I try to start it on both Cluster server.

I've got as well event ID errors
In System logs:

Event 1069 from FailoverClustering: Cluster resource ‘SQL Server (MOSS)’ in clustered service or application ‘SQL Server (MOSS)’ failed.

Event 1205 from FailoverClustering: The Cluster service failed to bring clustered service or application ‘SQL Server (MOSS)’ completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered service or application.

App logs:

All errors had the same EventID, 19019 from Failover

If I try to connect with the SQL Studio, I get the following error :
"Login failed for user sa. Reason : server is in script upgrade mode. Only Administrator can connect at this time."

Quick update: I tried to update the SQL server 2008 R2 to SP1 and it crashed. Now I just fixed the SP installation crash, restarted the server but the problem still there.

I've checked as well the Registry / DefaultData Reg_SZ which was empty and I've added it, tried again but no luck.

Even this didnt worked neither : http://support.microsoft.com/kb/2163980

Any clue on how solve this issue? I'm in rush situation.
Help will be a lot appreciate.

Regards,
poy
0
Comment
Question by:David_Pazos
  • 3
  • 2
5 Comments
 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
if it is an important prod server - open MS support Case ASAP

for now try to use the sql server  service startup trace  Add ;-T902
it should suppress the upgrade error

check the sqlo browser  service - it must be online
0
 

Author Comment

by:David_Pazos
Comment Utility
Hi,

thanks for your comment. Sadly, the T902 didn't resolve anything. I had to play in the registry and reinitiate several values to 1 in order to fix the Update issue. Nevertheless, it didnt resolve anything.
here are the docs and hotfix in case it may be useful to someone
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/7ad149bd-bd6d-4a9b-b6b1-a3c8a4deeea1/error-installing-sql-server-2008-r2-cumulative-update-6-cu6?forum=sqlsetupandupgrade
http://support.microsoft.com/kb/976761
http://support.microsoft.com/kb/2163980

I've opened a case by Microsoft, it costed at lot for nothing as I wait 12 hours for their call which never came.... I've finally mounted in the meantime a DR server and now we will destroy everything and rebuild from scratch.

I still don't understand what happened but I wish good luck it this happens to someone again.
Regards,
David
0
 

Author Comment

by:David_Pazos
Comment Utility
I've requested that this question be closed as follows:

Accepted answer: 0 points for David_Pazos's comment #a39634194

for the following reason:

no solution has been found.
0
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
Comment Utility
in any case - it is not a good idea to play with registry on cluster server
specially

the post sp error failure
has nothing to do with Reg and
MSDTS  is not the reason to for sql server resource not to start

Aftert you "fixede" registry
or you must rollback
 or wait for MS
or repair sql install (maybe reinstall)

---
BTW: All this post and my lost - is your solution
0
 

Author Comment

by:David_Pazos
Comment Utility
Thanks EugeneZ for your advice. It does make sense.

Moderator, please transfert points to him.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

743 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

18 Experts available now in Live!

Get 1:1 Help Now