Inner exception(1): The EXECUTE permission was denied on the object 'proc_putObject', database 'SharePoint_Config', schema 'dbo'

While i am deploying my solution in to sharepoint, it is showing:

"Inner exception(1): The EXECUTE permission was denied on the object 'proc_putObject', database 'SharePoint_Config', schema 'dbo'". Unable to deploy the solution.

Can 开发者_如何学Pythonany one give the solution.... Thank you.

To deploy an SharePoint solution (wsp) write access to the SharePoint Config database is required. You have to ensure that the executing user is a Farm Administrator.

I do not recommend changing the permissions on the DB manually as suggested by "System.Exception" since this is not supported by Microsoft.

As Share point uses the SQL Server as backend, I added my login id with admin permissions in SQL server. It is working fine.

Try to activate the feature using the stsadm command

stsadm -o activatefeature -name thisfeaturename> -url http://thisserver/

The login you are using to execute the sproc proc_putObject doesn't has permission to execute the sproc! For your login grant execute permission on this sproc!