Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server 2008 Cluster in Failed state

Posted on 2013-11-07
5
Medium Priority
?
793 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 2000 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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

722 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