Answered by:
Change the default organization

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.
thanksMonday, 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 AMModerator
All replies
-
Did you restart iis after doing this?
Alex - www.PowerObjects.com Bring the Focus Dynamics CRM Into FocusMonday, June 8, 2009 1:35 AM -
or atleast you need to reset the IISMonday, 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- Proposed as answer by Tiaan van Niekerk Monday, June 8, 2009 5:16 AM
- Unproposed as answer by Marco Amoedo MVPModerator Monday, June 8, 2009 7:17 AM
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 AMModerator -
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 -
Here You go : How to change the default organization for a CRM user
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