CRM database without Active Directory

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

CRM database without Active Directory

You may ask yourself now if for any reason you will have to use CRM database without access to Active Directory. And because I have written this post it means yes – it can happen, even very often 🙂


Some Clients for security reasons don’t give access to AD or provide a CRM database backup only. What then if you need to create some report by SSRS or integration package via SSIS? Of course if you will not use filtered views (eg. Filtered_Account) there will be no issue. Unfortunately most of the reports requires records filtering based on security roles.


Only thing that user needs to do is to find and change CRM built-in SQL function fn_FindUserGuid so it returns and organization administrator guid 🙂

P.S. If you found this post useful please rate it.

Have an own opinion?