Solved

SQL Server 2008 Cluster in Failed state

Posted on 2013-11-07
5
780 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 43

Expert Comment

by:Eugene Z
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 43

Accepted Solution

by:
Eugene Z 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

739 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