The SELECT permission was denied on the object ‘FilteredActivityPointer’, database ‘MicrosoftCRM_MSCRM’ schema ‘dbo’

If you received the following error.

The SELECT permission was denied on the object ‘BuildVersion’, database ‘MicrosoftCRM_MSCRM’, schema ‘dbo’ or the variation The SELECT permission was denied on the object ‘SystemUser’, database ‘MicrosoftCRM_MSCRM’, schema ‘dbo’

If you have tried changing the owner of new database with admin login making it as dbowner but did not help then following may help solving this problem

Right click the affected object (table/view etc) in my case it was ‘BuildVersion’ and ‘SystemUser’ in SQL Server Management Studio, click on properties click on “Permissions” on left tab click on “View schema permission” link on right tab click on “Add” button, click on “Browse” select “CRMReaderRole” of type Database role. click ok, click ok, now you will be again in object properties. Place check mark in “Grant” column against “Select” permission click ok

To change the dbowner command is (If required)

use <CRMDatabaseThatYouNeedToChangeTheOwner>

exec sp_changedbowner ‘DOMAIN\AdministratorMappedWithCrmAdmin’

go

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: