Sunday, September 20, 2015

How to fix: Access denied error on Dynamics CRM

When you receive an access denied error on the CRM screen and you want to find out what really failed?

Download the error log file and fetch the following details:

OwnerID, CallingUserID, ObjectTypeCode and ObjectID.

Get on to your SQL Server and analyse the error details using the below queries.

This will give you an idea why did it fail.

SELECT fullname FROM SystemUser Where SystemUserId = 'ownerid'

SELECT fullname FROM SystemUser Where SystemUserId = 'callinguserid'

SELECT ObjectTypeCode,* FROM ENTITYVIEW where ObjectTypeCode = ''

SELECT entityID, * FROM entity WHERE entityId = 'objectid'