Showing posts with label schema ‘dbo’. Show all posts
Showing posts with label schema ‘dbo’. Show all posts

Sunday, 29 June 2014

The EXECUTE permission was denied on the object ‘proc_putObject’, database ‘SharePoint_Config’, schema ‘dbo’

Sharepoint Error.
Error occurred in deployment step ‘Add Solution’: The EXECUTE permission was denied on the object ‘proc_putObject’, database ‘SharePoint_Config’, schema ‘dbo’.
This error i got because i don’t have “SharePoint Shell Access” on “SharePoint_Config” DB.
How did i solve this issue?
Simple you can open SQL server.
Go to Security–>login–>[Domain\MyName]
Right click–>properties.
Click on User Mapping.
Select “SharePoint_Config” database in the —–Users Mapped to this login section:
Select “SharePoint_Shell_Access” in the —Database role membership for :SharePoint_Config
Cool, i got the solution……now i don’t have that error.