These are the only errors I get....

In the event viewer:

The service cannot be started: Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be...

I checked both - there are errors in the Event Viewer but no useful error messages. Unfortunately I suspect the installation may be corrupt in some way, but I don't...

On further investigation I've noticed that the master.vmp file is empty - it must have been wiped or corrupted when the service cut out. Do you know if there is...

I've found a couple of interesting entries in the OLAP log....

(30/09/2013 13:13:20) Message: Failed to initialize SQLSQM timer. One of the following can be the source of the problem: registry...

I'm still a little confused....I've found the following information about the exact scenario I was referring to:

SPID Type ...

Thanks Gila, that's really helpful 😎

Sorry I might have been a bit premature posting this - it appears my monitoring tool was not refreshing correctly. After a bit more in-depth investigation it looks like the...

Hi Perry,

Thanks for responding - yes the disks are presented as...

Sussed it! The AD group is on a different domain and they had set it up as a 'Domain local' group rather that a 'Global' group. It still...

Further to this I've just found the following in the SQL error logs:

"Login failed for user 'DOMAIN\User'. Reason: Token-based server access validation failed with an infrastructure error."

AndrewSQLDBA (12/9/2013)

---

Sounds like you have the "Default" database set to a database that the login does not have access. Check that, and make certain you change the database name to...

Thanks for all the suggestions guys - interesting to see how people prefer to do it.

Think I have my plan sorted now. Fortunately I will have the new cluster...

Perry Whittle (8/6/2013)

---

matt.gyton (8/6/2013)

---

Thanks all for the responses...

There is a chance the new servers...

Joie Andrew (8/6/2013)

---

Once the new clusters are up you can also look at things like db mirroring or log shipping. That way the data is already replicating over to the...

Thanks all for the responses...

There is a chance the new servers will have Windows...