Solved

SQL Server 2008 Cluster in Failed state

Posted on 2013-11-07
5
773 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
ID: 39634086
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
ID: 39634194
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
ID: 39638608
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
ID: 39634203
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
ID: 39638609
Thanks EugeneZ for your advice. It does make sense.

Moderator, please transfert points to him.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
TSQL DateADD update Question 4 38
Extract string portion 2 24
Replace Dates in query 14 38
Sql Server group by 10 26
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

785 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