locked
Change the default organization RRS feed

  • Question

  • I have 2 organisation A and B. when i first installed crm i have put B and then i imported A. when i open CRM without specifying the org name, B will come as the default one. how to change it so A will come if i didnt specofy anything.
    i made A as default organisation and change the registry but no luck.

    thanks
    Monday, June 8, 2009 1:19 AM

Answers

  • Hi Tony,

    The default organisation will no change for the already created users, this change will only be applied for new users created after the change. This means that this changes is not applied in a retroactive fashion, only the new users that you create will have that organisation as default.

    Each user record have stored the default organisation, so you would need to change them for each one of the already created users. You have two mechanisms. Either use this tool provided by Microsoft Support http://cid-367e225194cd489d.skydrive.live.com/self.aspx/downloads/ChangeDefaultOrganization.zip

    Or directly modify the CRM Database to change the DefaultOrganizationId on the SystemUser table (like it is proposed here http://chicagotech.net/netforums/viewtopic.php?t=6046)

    In either case, make a backup of the databases before just in case.

    Hope it helps


    Marco Amoedo - http://marcoamoedo.com
    • Marked as answer by Matt Parks Monday, June 8, 2009 9:28 PM
    Monday, June 8, 2009 7:45 AM
    Moderator

All replies

  • Did you restart iis after doing this?
    Alex - www.PowerObjects.com Bring the Focus Dynamics CRM Into Focus
    Monday, June 8, 2009 1:35 AM
  • or atleast you need to reset the IIS
    Monday, June 8, 2009 4:58 AM
  • HI open deployment manager.Select ORG B and set as default. Restart IIS
    Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1
    Monday, June 8, 2009 5:16 AM
  • Hi Tony,

    The default organisation will no change for the already created users, this change will only be applied for new users created after the change. This means that this changes is not applied in a retroactive fashion, only the new users that you create will have that organisation as default.

    Each user record have stored the default organisation, so you would need to change them for each one of the already created users. You have two mechanisms. Either use this tool provided by Microsoft Support http://cid-367e225194cd489d.skydrive.live.com/self.aspx/downloads/ChangeDefaultOrganization.zip

    Or directly modify the CRM Database to change the DefaultOrganizationId on the SystemUser table (like it is proposed here http://chicagotech.net/netforums/viewtopic.php?t=6046)

    In either case, make a backup of the databases before just in case.

    Hope it helps


    Marco Amoedo - http://marcoamoedo.com
    • Marked as answer by Matt Parks Monday, June 8, 2009 9:28 PM
    Monday, June 8, 2009 7:45 AM
    Moderator
  • In CRM 2011 and CRM 4.0 we have an option to set any non-default Org as default Org in Deployment manager but unfortunately we can not change the default org for the user from there.

    So how to change the Default Org for any user(in supported way) if that user is a part of two different Orgs in the same CRM deployment is a big question?

     

    I found this interesting behavior that how the Default CRM URL (http://Servername:Portno/) redirection happens in CRM 4.0 and CRM 2011: The default CRM server URL always hit the Org in which the user is created first, no matter it is a Default Org or a non-default Org.

     

    For Example: There are two Orgs Org A and Org B, and I am creating a user say A in Org B first and then in Org A(default Org). Now in this scenario when we hit the URL http://Servername:Portno/ it will hit the Org B and not Org A(default Org). However, if we reverse the Order that is creating the same user A in Org A(Default Org) then creating it in Org B (Non Default Org) and then if we hit the URL http://Servername:Portno/ it will go to Org A(default Org) which every one aware ofJ

     

    An in order to change the Default Org for any user, we need to create Dummy user in AD. Mapping this Dummy user to the current Default Org user will allow the non-Default user to use the Default server URL.

     

    I have tested  this scenario where after mapping the default Org User to the Dummy user will allow the non-default Org user to use default serve URL http://Servername:Portno/

     

    Sunday, January 22, 2012 12:31 AM
  • Monday, February 27, 2012 11:27 PM
  • Hi,

    1.  Go to SQL Server where CRM installed

    **Kindly change the GUID's**

    2. Use MSCRM_CONFIG

    Select * from organization

    You can find the list of organization in your CRM.

    3.  Find the User’s Systemuserid

    Or

    You can also find the user GUID using this query:

    Use <<Your Organization>>_MSCRM

    Select systemuserid from systemuserbase where domainname = ‘domain\user’

    systemuserid = <6893E7A3-62B8-E011-AA60-000C292CBBE1>

    4. Find the User’s ID:

    Use MSCRM_CONFIG

    Select userid from systemuserorganizations where crmuserid = <6893E7A3-62B8-E011-AA60-000C292CBBE1> User ID <E0437EA7-9B8B-E011-9245-000C292CBBE1>

    5. Find the appropriate user in the systemuser table

    Select * from systemuser where id = ‘E0437EA7-9B8B-E011-9245-000C292CBBE1’

            - Update the systemuser table to reflect the desired defaultorganizationid

    6. Use MSCRM_CONFIG

    Update SystemUser set DefaultOrganizationId = '6893E7A3-62B8-E011-AA60-000C292CBBE1’ Where id = 'E0437EA7-9B8B-E011-9245-000C292CBBE1'

    DO IISRESET and access the CRM

    Regards,


    Khaja Mohiddin http://www.dynamicsexchange.com/ http://about.me/KhajaMohiddin

    Tuesday, February 28, 2012 4:13 PM