Anasayfa » Forum

Cannot open databas...
 

Cannot open database "OperationsManager" requested by the login. The login failed. Login failed for user 'XXX\Scom'  

  RSS
drivers123
(@drivers123)
Üye

Merhaba,

Uygulamalar izlemek için server 2008 stnd üzerine scom 2012 r2 ve SQL server 2012 kurdum. De faul olarak yaptigim kurulumdan sonra herşey caliyordu. Fakat bugün asagidaki hatayi almaya başlar im ve bir turlu çözüm bulamadim. Microsoft ve diğer sitelerden çözüm için arastirmalar yaptim fakat sonuç olumsuz. Benim derdime derman olacak bir makale bulamadim. Çok acil olarak yardim ve onerilerinizi bekliyorum

 

 

OpsMgr Management Configuration Service failed to execute bootstrap work item 'ConfigurationDataProviderInitializeWorkItem' due to the following exception

System.Data.SqlClient.SqlException (0x80131904): Cannot open database "OperationsManager" requested by the login. The login failed. Login failed for user 'XXX\Scom'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
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, TaskCompletionSource1 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(TaskCompletionSource1 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:e54564ff-b6ca-4241-b9db-e7922da1e832

 

Kolay gelsin

Zafer 

Alıntı
Gönderildi : 17/04/2014 03:49
Halil Ugur Acikgoz
(@haliluguracikgoz)
Üye

Merhaba,

 Hangi aşamada bu hatayı alıyorsun? SCOM konsolunu açarken mi? Ekran görüntüsü paylaşmanız mümkün mü? SCOM ile SQL aynı sunucu üzerinde mi? 

CevapAlıntı
Gönderildi : 17/04/2014 21:47
Serkan UZUNER
(@serkanuzuner)
Üye

Selam

 

urunu kurali 180 gun oldu mu ?, lisans anahtarini powershell uzerinden girmismiydiniz ?  

CevapAlıntı
Gönderildi : 19/04/2014 18:22
drivers123
(@drivers123)
Üye

Makineyi yeniden başlatıyorum. event viewer'da bu hatayı alıyorum. SCOM ile SQL aynı makinede. windows authentication ile bağlanmayı deniyorum. Makineye girdiğim kullanıcı servis'leride çalıştıran kullanıcı. Servis'ler düzgün bir şekilde çalışıyor görünüyor. Fakat SCOM artık monitör etmiyor bu hatadan dolayı. Bu hatadan 4 saniye önce 28001 hatası alıyorum. 

 

The Root connector received an exception from the Config Service on StateSyncRequest: 

System.Runtime.Remoting.RemotingException: Failed to connect to an IPC Port: The system cannot find the file specified.

 

Server stack trace: 

   at System.Runtime.Remoting.Channels.Ipc.IpcPort.Connect(String portName, Boolean secure, TokenImpersonationLevel impersonationLevel, Int32 timeout)

   at System.Runtime.Remoting.Channels.Ipc.ConnectionCache.GetConnection(String portName, Boolean secure, TokenImpersonationLevel level, Int32 timeout)

   at System.Runtime.Remoting.Channels.Ipc.IpcClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream)

   at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]: 

   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

   at Microsoft.EnterpriseManagement.Mom.Internal.IConfigService.OnStateSyncRequest(Guid source, UInt64 messageIdentifier, String cookie)

   at Microsoft.Mom.Connectors.Root.RootConnector.OnStateSyncRequest(Guid source, UInt64 messageIdentifier, String cookie) 

 Bununla birlikte kuralı 2 ay oldu. Lisans sorunu olmayacağını düşünüyorum. 

Önerilerinizi bekliyorum

 

Kolay gelsin 

CevapAlıntı
Gönderildi : 24/04/2014 21:09
drivers123
(@drivers123)
Üye

Serkan bey merhaba,

Başka önerileriniz olabilir mi acaba? Sorun halen devam ediyor ve çözüm bulamadım halen!

Önerileriniz için şimdiden çok teşekkürler

Kolay gelsin

Zafer 

 

 

CevapAlıntı
Gönderildi : 29/04/2014 13:27
Paylaş:

Lütfen Giriş yap yada Kayıt ol