Hinweis: Dieser Artikel wurde ursprünglich veröffentlicht in 2013. Einige Schritte, Befehle oder Softwareversionen haben sich möglicherweise geändert. Überprüfen Sie die aktuelle Dokumentation von Sharepoint 2013 für die neuesten Informationen.

Voraussetzungen

Bevor Sie beginnen, stellen Sie sicher, dass Sie Folgendes haben:

  • 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 Sicherheit, 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”)

Zusammenfassung