- So you were trying to Restore CRM database on another machine?
- You used the Deployment Manager to Import Organization?
- You tried to load CRM using the browser but received something you didn't want to see
The SELECT permission was denied on the object 'Build Version', database ', schema 'dbo'.
No wonder you reached this blog post. Read on. This might help:
- Open SQL Server Management Studio
- Select the CRM Database you are working with
- Right-click the BuildVersion table from the CRM Database and click Properties
- Select Permissions tab on the left pane
- Click on View Schema Permission on the right pane
- Click on Add button
- Click Browse
- Select CRMReaderRole of type Database Role
- Click OK twice (Back to Table Properties Window)
- Check the intersection Select vs. Grant
- Click OK
You should be good to go.
