Skip to content

April 10, 2012

Upgrading to SCOM 2012 – SQL Issue

I ran into an issue when upgrading SCOM to 2012 (from 2007 R2 CU5).  The installer stated that the upgrade was successful, but no activity was taking place in my management group.  I had one error in my event logs (see below).

The issue was that my OperationsManager (and OperationsManagerDW) databases were set to SQL 2005 compatibility mode.  Apparently, SCOM 2012 requires this to be set to SQL 2008.  I discovered this solution from a great blog post by Mr. Denny (http://itknowledgeexchange.techtarget.com/sql-server/upgrading-ms-ops-manager-sql-server/).  I just wanted repost this issue since I could see a lot of people running into this problem.  This issue is also not documented anywhere in MS documentation.

***UPDATE***: Microsoft just released the following KB article on this issue: http://support.microsoft.com/kb/2700028

——————-
Log Name:      Operations Manager
Source:        OpsMgr Management
Event ID:      29112

OpsMgr Management Configuration Service failed to execute bootstrap work item ‘ConfigurationStoreInitializeWorkItem’ due to the following exception

Microsoft.EnterpriseManagement.ManagementConfiguration.DataAccessLayer.DataAccessException: Data access operation failed

at Microsoft.EnterpriseManagement.ManagementConfiguration.DataAccessLayer.DataAccessOperation.ExecuteSynchronously(Int32 timeoutSeconds, WaitHandle stopWaitHandle)

at Microsoft.EnterpriseManagement.ManagementConfiguration.SqlConfigurationStore.ConfigurationStore.ExecuteOperationSynchronously(IDataAccessConnectedOperation operation, String operationName)

at Microsoft.EnterpriseManagement.ManagementConfiguration.SqlConfigurationStore.ConfigurationStore.Initialize()

at Microsoft.EnterpriseManagement.ManagementConfiguration.Engine.ConfigurationStoreInitializeWorkItem.ExecuteWorkItem()

at Microsoft.EnterpriseManagement.ManagementConfiguration.Interop.ConfigServiceEngineWorkItem.Execute()

———————————–

Microsoft.EnterpriseManagement.ManagementConfiguration.DataAccessLayer.DataAccessException: Data access operation failed to run SQL script. The following are the first 200 characters of the first failed batch

——

Share your thoughts, post a comment.

(required)
(required)

Note: HTML is allowed. Your email address will never be published.

Subscribe to comments