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.
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.