Dynamics CRM 2011 Organization Import from SQL 2012 AlwaysOn DB RRS feed

  • Question

  • I am trying to import the CRM organization (Dynamics CRM 2011) from CRM DB  (SQL 2012 AlwaysOn) using Availability Group Listener.  The Organization import wizard fails with this error in CRM log: 

    "Error| Check CrmSqlDomainValidator : Failure: The SQL Server 'xxx-listener_name' is unavailable."

    When I point it to one of the nodes (i.e. primary node in two node Availability Group), I have no issue importing.  It is slow but finishes the organization import process.

    The DB permission is fine (i.e the user ID I am using to import has the sys admin on the DB) and FW rules are setup to allow CRM to communicate to SQL (i.e. 1433, 445, 135, UDP/TCP ports)

    Is it even supported between CRM 2011 and SQL 2012 AlwaysOn?

    No other log entry except the above from the CRM log.

    Thursday, May 29, 2014 7:55 AM

All replies

  • Hi,

    We do have a similar situation. During Organization Imports we will change the SQL Server name to primary Instance name in MSCRM > ConfigDB.

    After the Import is successful, we change the value back to listener.

    It is not related to any FW rules, even the MSDN article says to use the primary replica during installation and change it to Listener later.


    Manoj Batchu

    Thursday, June 12, 2014 12:35 PM
  • Hi,

     This may not help you. But for future reference, If your agent is already running, use the registry key IgnoreChecks and click Next after error. This will proceed to the next step and import the organisation. There is no need to point to a node to create a new organisation/Import a new organisation or during upgrades. (Only for initial installation). Pointing to Listener works.

    Path: [HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM] 
    • Type: Dword
    • Name: IgnoreChecks
    • Value: 1



    Tuesday, February 16, 2016 10:51 PM