locked
CRM 2013 / SQL 2012 Availability Group security login issue RRS feed

  • Question

  • Hello All,

    I am trying to configure an availability group for a new CRM 2013 environment.  I have a problem when trying to create the CRM groups security logins on the second SQL node. 

    On this step:

    Start SQL Server Management Studio and connect to the secondary SQL Server replica (CRMNode2).

    Expand the Security node, right-click Logins and then click New Login.

    In the Login name box, click Search, make sure that Groups is included in the Select this object type (if not click Object Types and add it). Type DomainName\PrivReportingGroup, click Check Names, and when the name resolves correctly, click OK.

    Click the User Mapping page and select the MSCRM_CONFIG database and all the OrganizationName_MSCRM databases, and then click OK on the Login - New dialog box to close and save the new login.

    Repeat steps 2 through 4 for the following security groups.

    ReportingGroup

    SQLAccessGroup

    When click on User Mapping I get the following error:

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------
    ADDITIONAL INFORMATION:

    The target database ('Orgname_MSCRM') is in an availability group and is currently accessible for connections when the application intent is set to read only. For more information about application intent, see SQL Server Books Online. (Microsoft SQL Server, Error: 978)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.3339&EvtSrc=MSSQLServer&EvtID=978&LinkId=20476

    Any help would be greatly appreciated.

    Thanks

    Tuesday, July 8, 2014 10:50 PM