Question Status

Unanswered
sami selmani asked a question on 26 Mar 2015 6:56 PM

i  have a error  in console deploiement CRM 2011 to connect to MSCRM_CONFIG when I Failover SQL 2012 DATABASE.

I just applied the following article https://technet.microsoft.com/en-us/library/hh699791(v=crm.5).aspx but i have error in MMC dep CRM 2011

Reply
Allan Silva responded on 31 Mar 2015 9:08 PM

HI Sami,

Can you please provide more details on the error you are seeing?

Thank you for using Microsoft Dynamics CRM Communities,
Dynamics CRM Support Blog

Allan Silva
Support Engineer
Microsoft Dynamics CRM

Reply
sami selmani responded on 1 Apr 2015 4:08 AM

Hi ALLan,

I just installed crm 2011 with 2 noeuds sql server 2012 configured with mirroring,and automatic failover.
when I restart the main noeud ( active) :

failover OK :

  • noeud active = secondary
  • noeud secondary= active

CRM OK  but delpoiement CRM console (MMC) does not work.

error :

FX:{1ac9de3e-24ae-480d-9e15-65386b76e433}

Impossible d'ouvrir la base de données "MSCRM_CONFIG" demandée par la connexion.La connexion a échoué.
Échec de l'ouverture de session de l'utilisateur 'CONTOSO\Administrateur'.

à System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
à System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
à System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
à System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
à System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
à System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
à System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
à System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
à System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
à System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
à System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
à System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
à System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
à System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
à System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
à System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
à System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
à System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
à System.Data.SqlClient.SqlConnection.Open()
à Microsoft.Crm.CrmDbConnection.Open()
à Microsoft.Crm.Setup.Server.Utility.CrmServerUtility.GetConfigDatabaseVersion(String sqlServerName, String configDatabaseName)
à Microsoft.Crm.Tools.Admin.DMSnapInController.IsConfigDBVersionSupported()
à Microsoft.Crm.Tools.Admin.DMSnapInHelper.DisplayMessageBoxIfConfigDBNotSupported(Console console)
à Microsoft.Crm.Tools.Admin.DMSnapIn.OnInitialize()
à Microsoft.ManagementConsole.SnapInBase.Initialized()
à Microsoft.ManagementConsole.Internal.SnapInClient.Microsoft.ManagementConsole.Internal.ISnapInClient.Initialize(ISnapInPlatform snapInPlatform)
à Microsoft.ManagementConsole.Executive.SnapInInitializationOperation.OnStart()
à Microsoft.ManagementConsole.Executive.RunningOperationsTable.EnqueueOperation(Operation operation)
à Microsoft.ManagementConsole.Advanced.FrameworkSnapInFactory.Microsoft.ManagementConsole.Advanced.ISnapInFactory.CreateSnapIn(Int32 bookkeepingId, String snapInKey, Object& snapIn)

"contoso\administrateur" and "network service" have role sysadmin in 2 noeuds SQL.

thanks,

Reply