A few weeks ago I experienced something strange in CRM 2011. I created a HTML webresource, added to the form, but some users could not see the resource. When they tried to open the webresource the following screen appeared while opening the following URL:
I’ve check the security roles, tried with different users on different machines, cleared the cache, modified my test user to the same of the users with the error… But nothing worked.
Finally the reasons seemed to be that there was no organization specified in the URL. So changing:
fixed the problem.
But of course, that doesn’t explain why this only happened to specific users. The reasons is that when no organization is specified in the URL, CRM picks the default organization for the signed in user. DefaultOrganizationId is a field in the “systemuser” table that is set for each user. To change this you can follow those steps:
- Go to SQL Server where MS Dynamics CRM 2011 installed:
You can find the list of organization in your CRM.
- Find the User’s Systemuserid. You can also find the user GUID using this query:
WHERE domainname = ‘domain\user’
For example: systemuserid = <6893E7A3-62B8-E011-AA60-000C292CBBE1>
- Find the User’s ID:
WHERE crmuserid = ‘6893E7A3-62B8-E011-AA60-000C292CBBE1’
For example: User ID = <E0437EA7-9B8B-E011-9245-000C292CBBE1>
- Find the appropriate user in the systemuser table
WHERE id = ‘E0437EA7-9B8B-E011-9245-000C292CBBE1’
- Update the systemuser table to reflect the desired defaultorganizationid
SET DefaultOrganizationId = ‘6893E7A3-62B8-E011-AA60-000C292CBBE1’
WHERE id = ‘E0437EA7-9B8B-E011-9245-000C292CBBE1′
- Run IISRESET and access the MS Dynamics CRM 2011
Hope this helps to keep you productive!