SCVMM error after applying CU5 to SQL 2012 SP2

Virtual Machine Manager stopped working after I applied CU5 to the SQL 2012 SP2 database. The following error message was recorded in the Event Viewer on the VMM server:

Service cannot be started. Microsoft.VirtualManager.DB.CarmineSqlException: Unable to connect to the VMM database because of a general database failure.
Ensure that the SQL Server is running and configured correctly, then try the operation again. —> System.Data.SqlClient.SqlException: Login failed for user ‘{Service Account}’. Reason: Server is in script upgrade mode. Only administrator can connect at this time.

The database was housed on a shared server and none of the other applications were reporting issues. There are several potential causes for this error reported in various blogs. One of the potential causes is Agent XPs being disabled during the update; however, when I ran sp_configure, it showed Agent XPs as being enabled.

None of the other causes made much sense in this case, and the following message was reported in the SQL Error Log:

Configuration option ‘Agent XPs’ changed from 1 to 0. Run the RECONFIGURE statement to install.

I ran the following even though it was showing Agent XPs as enabled:

sp_configure 'Agent XPs', 1

After that, the Virtual Machine Manager connected to the database and worked fine.

SCVMM error after applying CU5 to SQL 2012 SP2

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s