CRM 2011 Change The Default Organization


Eg.
Server Name : http://111.11.11.11/
Organization : Test1
Organization : Test2

In internet explorer when we key in server name into the URL default organization will be selected.
Let say the default organization for this server name is Test1 and when u key in the server name into the url the link will be  http://111.11.11.11/Test1/. Default organization will be selected automatically.

How do we actually change the default organization ?

Here what i found. Default organization is based on user. That mean each user have their own default organization.

Here the way to do it.

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.

4. Find the User’s ID:
    Use MSCRM_CONFIG 
    Select userid from systemuserorganizations where crmuserid = <6893e7a3-62b8-e011-aa60-000c292cbbe1> User ID 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 2. 

 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

This is where i done everything update and find. Eg Picture attached.

0 comments: