Thanks all, I have found the problem but not the resolution as yet.
The problem is with SQL 2014 Always-On. When the Operations DB or DW are running as the active role on the secondary node SCOM cannot access the databases. Will keep looking into this and report back when I have a solution. Peter Hakesley | Monitoring & Automation Technical Lead Engineer, Data Centre Services t: +44(0)845 155 6556 ext: 4006 e: [email protected] | w: www.scc.com<http://www.scc.com/> a: SCC, CV1, Cole Valley, 20 Westwood Avenue, Tyseley, Birmingham B11 3RZ From: [email protected] [mailto:[email protected]] On Behalf Of Kevin Holman Sent: 07/April/2016 20:33 To: [email protected] Subject: [msmom] RE: SCOM 2012 R2 SDK Service is failing Login failed usually means there is a bad password somewhere. Check the service account running the SDK/DAS service, the service account running the Config service, then check each RunAS account where SVC_SCOMDA is used and reset those passwords. You said in your email "SCOM is saying it cannot write to the OPSDW" but the event you showed has nothing to do with the DW - it is Config - which is a totally separate process. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Pete Hakesley Sent: Wednesday, April 6, 2016 8:59 AM To: MSMOM ([email protected]<mailto:[email protected]>) <[email protected]<mailto:[email protected]>> Subject: [msmom] SCOM 2012 R2 SDK Service is failing Can you help me please? SCOM is saying it cannot write to the OPSDW below using Account SVC_SCOMDA however this account is a local admin and has SQL login/and appropriate rights. I have checked that it can read and write data to tables in the DW database. However I keep getting this and then the SDK service fails. DB space and Log space is OK I am told the SAN is ok I cannot figure out what the problem actually is. OpsMgr Management Configuration Service failed to execute bootstrap work item 'ConfigurationDataProviderInitializeWorkItem' due to the following exception System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'ENTCOREMGMT\SVC_SCOMDA'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.EnterpriseManagement.ManagementConfiguration.DataAccessLayer.ConnectionManagementOperation.Execute() at Microsoft.EnterpriseManagement.ManagementConfiguration.DataAccessLayer.DataAccessOperation.ExecuteSynchronously(Int32 timeoutSeconds, WaitHandle stopWaitHandle) at Microsoft.EnterpriseManagement.ManagementConfiguration.CmdbOperations.CmdbDataProvider.Initialize() at Microsoft.EnterpriseManagement.ManagementConfiguration.Engine.ConfigurationDataProviderInitializeWorkItem.ExecuteWorkItem() at Microsoft.EnterpriseManagement.ManagementConfiguration.Interop.ConfigServiceEngineWorkItem.Execute() ClientConnectionId:a6033fef-a1a0-440b-adfe-8528a289907a Peter Hakesley | Monitoring & Automation Technical Lead Engineer, Data Centre Services t: +44(0)845 155 6556 ext: 4006 e: [email protected]<mailto:[email protected]> | w: www.scc.com<https://na01.safelinks.protection.outlook.com/?url=http%3a%2f%2fwww.scc.com%2f&data=01%7c01%7ckevin.holman%40microsoft.com%7c7fbba631207f4e57fc7208d35f1ab740%7c72f988bf86f141af91ab2d7cd011db47%7c1&sdata=N%2fIxUJknERcio0XuSNTiDP1Iv%2fhQDoHcYTwbXC4ptAE%3d> a: SCC, CV1, Cole Valley, 20 Westwood Avenue, Tyseley, Birmingham B11 3RZ
