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

  • Article

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 a farm configuration. Thus you need to give permission exclusively to this Object.

First, you need to Connect to SharePoint Database using a 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.

https://lh3.googleusercontent.com/-ZJ96qx6Rnd8/WMel57cT9MI/AAAAAAAAPsA/y3jp5Ziwit4/image_thumb%25255B8%25255D.png?imgmax=800

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

https://lh3.googleusercontent.com/-w5k-e-tgTOo/WMel70p1OPI/AAAAAAAAPsI/TyycjsUOT3M/image_thumb%25255B10%25255D.png?imgmax=800

And click Search.. and select Object Type in the window and click OK.

https://lh3.googleusercontent.com/-sCRU7UxlPME/WMel9sx0SOI/AAAAAAAAPsQ/rL4Cu9Qwy6c/image_thumb%25255B12%25255D.png?imgmax=800

Then click on Object Types and select the Stored Procedure.

https://lh3.googleusercontent.com/-fYhgEhWEn7U/WMel_Z_8paI/AAAAAAAAPsY/wkkLPGxz8fc/image_thumb%25255B14%25255D.png?imgmax=800

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

https://lh3.googleusercontent.com/-ZW4vT0iZ29o/WMemBfTGrBI/AAAAAAAAPsg/w0gtWJsqraU/image_thumb%25255B16%25255D.png?imgmax=800

Select the item and click OK.

https://lh3.googleusercontent.com/-sOnLiyLKgMc/WMemDFD5YOI/AAAAAAAAPso/LQHv9NRn1mc/image_thumb%25255B18%25255D.png?imgmax=800

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

https://lh3.googleusercontent.com/-ddfmO-d4UEw/WMemFMEePgI/AAAAAAAAPsw/dDNzfau3cSY/image_thumb%25255B20%25255D.png?imgmax=800