Forum

Cannot open databas...
 
Bildirimler
Hepsini Temizle

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

5 Yazılar
3 Üyeler
0 Reactions
1,152 Görüntüleme
(@drivers123)
Gönderiler: 8
Active Member
Konu başlatıcı
 

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 

 
Gönderildi : 17/04/2014 03:49

(@haliluguracikgoz)
Gönderiler: 29
Eminent Member
 

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? 

 
Gönderildi : 17/04/2014 21:47

(@serkanuzuner)
Gönderiler: 1040
Illustrious Member
 

Selam

 

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

 
Gönderildi : 19/04/2014 18:22

(@drivers123)
Gönderiler: 8
Active Member
Konu başlatıcı
 

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 

 
Gönderildi : 24/04/2014 21:09

(@drivers123)
Gönderiler: 8
Active Member
Konu başlatıcı
 

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 

 

 

 
Gönderildi : 29/04/2014 13:27

Paylaş: