Tuesday, February 14, 2017

Insufficient SQL database permissions for user 'Name: doman\SP_UserProfiles SID:

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.

image

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

image

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

image

Then click on Object Types and select the Stored Procedure.

image

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

image

and select the item and Click Ok.

image

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

image

Post a Comment