Solved

SQL Server 2008 Cluster in Failed state

Posted on 2013-11-07
5
775 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SHOWPLAN permission denied in database 'AdventureWorks'. 13 111
SQL 2008 with .NET 4.5.2 4 35
sql how to count case when 4 26
sql 2016 Integration Service connecting to 2012 3 33
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…
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.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

808 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