What have you changed recently? That error is similar to one that you would receive if the SCOM DB does not have a $MACHINE$ login, just a user login. It needs both.
On Wed, Apr 6, 2016 at 8:59 AM, Pete Hakesley <[email protected]> wrote: > 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] <[email protected]>* | w: www.scc.com > a: SCC, CV1, Cole Valley, 20 Westwood Avenue, Tyseley, Birmingham B11 3RZ > > > > > > > >
