How to: Resolve error The EXECUTE permission was denied on the object ‘proc_putObjectTVP’, database ‘SharePoint_Config’ when using SharePoint 2013

How to: Resolve error The EXECUTE permission was denied on the object ‘proc_putObjectTVP’, database ‘SharePoint_Config’ when using SharePoint 2013

My saga with SharePoint is still far from over apparently. The latest and greatest error message found on the event log 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 installer, the user account used was configured by the installer, and on the SQL server I see it has the special 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 Microsoft and sort this out I will go with the following:

• DataWriter
• DataReader

To do this you will have to use the 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:

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:        Microsoft-SharePoint Products-SharePoint Foundation

Date:          20/03/2013 05:15:10 p. m.

Event ID:      5214

Task Category: Database

Level:         Critical

Keywords:

User:

Computer:      SharePoint2013

Description:

Insufficient SQL database 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”>

<System>

<Provider Name=”Microsoft-SharePoint Products-SharePoint Foundation” Guid=”{6FB7E0CD-52E7-47DD-997A-241563931FC2}” />

<EventID>5214</EventID>

<Version>15</Version>

<Level>1</Level>

<Task>3</Task>

<Opcode>0</Opcode>

<Keywords>0x4000000000000000</Keywords>

<TimeCreated SystemTime=”2013-03-21T00:15:10.533208300Z” />

<EventRecordID>5979</EventRecordID>

<Correlation ActivityID=”{95C7099C-C406-E062-D931-E9043219EC63}” />

<Execution ProcessID=”4636″ ThreadID=”7068″ />

<Channel>Application</Channel>

<Computer></Computer>

<Security UserID=”S-1-5-21-844968786-3793298798-2490560396-1613″ />

</System>

<EventData>

Name: SID: S-1-5-21-844968786-3793298798-2490560396-1613 ImpersonationLevel: None

<Data Name=”string1″>SharePoint_Config</Data>

<Data Name=”string2″>SQL</Data>

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

</EventData>

</Event>

 

Related articles

• How to: Give SharePoint 2013 crawler sufficient rights/permissions to crawl file shares
• How to: Enable SharePoint 2013 Central Administration when it displays “HTTP Error 503. The service is unavailable.”