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.