Insufficient SQL database permissions for user Name: NT AUTHORITY\IUSR SID: S-1-5-17
05/02/2012 Leave a comment
Solution:
In order to resolve the issue, I provided Execute permission to the database role “WSS_Content_Application_Pools” into the stored procedure “proc_GetProductVersions”. I performed the following steps to do this.
- In the database server, expand SharePoint Config database and naviage to Programmability/Stored Procedures/dbo.proc_GetProductVersions using SQL Server Management Studio.
- Right click on the above stored procedure and select Properties.
- On the popup screen, select Permissions on the left and click Search button.
- On the new popup screen, click Search, select [WSS_Content_Application_Pools] database role and click OK.
- Click OK again.
- On the first popup screen, select the role, check Execute permission and click OK.