locked
CRM 2011 With SQL 2012 Miroring RRS feed

  • Question

  • Hi, 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

    I just applied the following article https://technet.microsoft.com/en-us/library/hh699791(v=crm.5).aspx 

    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.

    could you help me.

    thanks,

    Monday, April 6, 2015 3:28 PM

All replies

  • Is the deployment pointing at the virtual SQL server name for the cluster, rather than for a single one of the servers?

    Hope this helps.
    Adam Vero, Microsoft Certified Trainer | Microsoft Community Contributor 2011
    UK CRM Guru Blog

    Monday, April 13, 2015 11:18 AM