I've inherited the install and configuration of a CRM 2015 system which has 2 SQL databases which are mirrored.
The CRM install was completed on the 01 (main) SQL connection.
I'm now setting up the 02 (secondary) SQL Server. The Org and MSCRM_Config databases exist on both SQL Servers and if one SQL Server is restarted the other database becomes the primary.
If the 02 SQL Server becomes the primary, I update the CRM Connection reg setting, and update the Org ConnectionString in SQL (as per https://technet.microsoft.com/en-us/library/hh699791%28v=crm.6%29.aspx?f=255&MSPPError=-2147217396).
The issue I have though is that some of the users/groups don't exist on the 02 SQL Server. When we first ran CRM in this state it complained about a user not having permissions. We created that user and it works fine now but I don't know what will happen when other users are added.
If I create another user in CRM does it make changes to the in-built SQL Groups to work? i.e. SQLAccessGroup?
Has anyone done an install similar to this? If so, what did they do with the security permissions on 02 SQL Server?
*This post is locked for comments
I have the same question (0)
