Note: This article was originally published in 2013. Some steps, commands, or software versions may have changed. Check the current Sharepoint 2013 documentation for the latest information.

In this step-by-step guide, you’ll learn resolve error the execute permission was denied on the object ‘proc_putobjecttvp’, database ‘sharepoint_config’ when using sharepoint 2013. SharePoint 2013 introduced social features, improved search, cross-site publishing, and enhanced mobile browsing experiences.

Prerequisites

Before you begin, make sure you have:

  • SharePoint Server 2013 or later
  • Farm administrator or site collection admin access
  • PowerShell with SharePoint snap-in

How to: Resolve error The EXECUTE permission was denied on the object ‘proc_putObjectTVP’, (http://en.wikipedia.org/wiki/Database “Database”) ‘(http://sharepoint.microsoft.com “Microsoft SharePoint”)_Config’ when using SharePoint 2013

My saga with SharePoint is still far from over apparently. The latest and greatest (http://en.wikipedia.org/wiki/Error_message “Error message”) found on the (http://en.wikipedia.org/wiki/Event_Viewer “Event Viewer”) reads “How to: Resolve error The EXECUTE permission was denied on the object ‘proc_putObjectTVP’, database ‘SharePoint_Config’ when using SharePoint 2013”. Obviously the database was created by the (http://en.wikipedia.org/wiki/Installation_%28computer_programs%29 “Installation (computer programs)”), the (http://en.wikipedia.org/wiki/User_%28computing%29 “User (computing)”) used was configured by the installer, and on the (http://www.iso.org/iso/catalogue_detail.htm?csnumber=45498 “SQL”) server I see it has the special (http://en.wikipedia.org/wiki/Filesystem_permissions “Filesystem permissions”) assigned by the installer… so what gives? Well, I wasn’t going to dig around too much but apparently giving the user the following rights solves the issue. Maybe it is too much but until I have time to reach out to (http://www.microsoft.com “Microsoft”) and sort this out I will go with the following:

To do this you will have to use the (http://microsoft.com/sqlserver “SQL Server Management Studio”). To configure these settings navigate to your Config database, select Security, then Logins. Right click the use SharePoint uses to connect and click properties. There you will find the permissions as noted in the image below: (http://technology.bauzas.com/files/2013/03/Technology.Bauzas.com-SharePoint-User-Database-role-membership.png)](http://technology.bauzas.com/files/2013/03/Technology.Bauzas.com-SharePoint-User-Database-role-membership.png) You can read more about permissions and security of SharePoint2013 here: http://msdn.microsoft.com/en-us/library/fp142383.aspx Below is a sample of the error message you may encounter:

Log Name: Application Source: (http://sharepoint.microsoft.com “Microsoft SharePoint”) Products-SharePoint Foundation Date: 20/03/2013 05:15:10 p. m. (http://en.wikipedia.org/wiki/Event_Viewer “Event Viewer”): 5214 Task Category: Database Level: Critical Keywords: User: Computer: SharePoint2013 Description: Insufficient (http://www.iso.org/iso/catalogue_detail.htm?csnumber=45498 “SQL”) permissions for user ‘Name: SID: S-1-5-21-844968786-3793298798-2490560396-1613 ImpersonationLevel: None’ in database ‘SharePoint_Config’ on SQL Server instance ‘SQL’. Additional error information from SQL Server is included below.   The EXECUTE permission was denied on the object ‘proc_putObjectTVP’, database ‘SharePoint_Config’, schema ‘dbo’. Event Xml: xmlns=“http://schemas.microsoft.com/win/2004/08/events/event”> 5214 15 1 3 0 0x4000000000000000 5979 Application Name: SID: S-1-5-21-844968786-3793298798-2490560396-1613 ImpersonationLevel: None SharePoint_Config SQL The EXECUTE permission was denied on the object ‘proc_putObjectTVP’, database ‘SharePoint_Config’, schema ‘dbo’.  

(http://img.zemanta.com/zemified_h.png?x-id=5606f864-546f-4a18-8617-a3fa4cbbca75)](http://www.zemanta.com/?px “Enhanced by Zemanta”)

Summary

You’ve successfully learned resolve error the execute permission was denied on the object ‘proc_putobjecttvp’, database ‘sharepoint_config’ when using sharepoint 2013. If you run into any issues, double-check the prerequisites and ensure your Sharepoint 2013 environment is properly configured.