Tuesday, September 12, 2017

Insufficient SQL database permissions for user 'Name: doman\SP_UserProfiles SharePoint 2013 User Profile

Insufficient SQL database permissions for user 'Name: doman\SP_UserProfiles SID: S-1-5-21-2738186777-3937669245-3595685374-1123 ImpersonationLevel: None' in database 'SharePoint_Config' on SQL Server instance 'ADXWSQL.adxweb.ae'. Additional error information from SQL Server is included below.

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

This is a caused by not having permission to database objects of using least privileges configuration in farm configuration. Thus you need to give permission exclusively to this Object.
First you need to Connect to SharePoint Database using privileged account.
Then go the SharePoint Config Database and security section. Then go to Roles and find WSS_Content_Application_Pools under the Database Roles section.

Double click (or Right Click -> Properties) the item and select the Securable section in the modal window.

And click Search.. and select Object Type in the Window and Click OK.

Then click on Object Types and select the Stored Procedure.

 Type proc_putObjectTVP  in Object names section and check names for select the item.

and select the item and Click Ok.

Then you can see the item in the securable and give the execute permission to the object.

Post a Comment