Geeks With Blogs

The Wrecking Bawl Destructuring query language, one keyword at a time.
I updated my production SQL Server 2012 cluster from SP1 to SP3 CU1 last night and had to spend an hour trying to figure out why the SQL Server Engine service wouldn't start for one of my two instances.  Weirdly the other instance worked fine after the upgrade.  The error logs were no help at all.  It was only by the magic of the gods that I happened upon a registry entry that still had the old patch level in it.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<instance>\Cluster\SharedDataPatchLevel

As soon as I updated the value to the correct level (since I saw in the setup log that the update was successful) I was able to start the service in the Failover Cluster Manager.
Posted on Tuesday, March 1, 2016 10:26 AM all tech stuff , SQL Server | Back to top

Comments on this post: sql server won't start as clustered resource after service pack upgrade

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Alex Bransky | Powered by: