Insufficient Database permissions – proc_GetProductVersions \ EventID 5214
After applying SharePoint2010 Service Pack 1 and the republished June CUP I encountered a strange error in the eventlog.
“Insufficient SQL database permissions for user ‘Name: <user id> SID: <GUID> ImpersonationLevel: Impersonation’ in database ‘SharePoint_Config’ on SQL Server instance ‘<DB Server>’. Additional error information from SQL Server is included below.
The EXECUTE permission was denied on the object ‘proc_GetProductVersions’, database ‘SharePoint_Config’, schema ‘dbo’.”
After a little bit of investigation I figured out how to reproduce the error.
- Click on a SharePoint site the SiteActions menu
- Click “New Site”
- When the silverlight menu opens the error gets written into the eventlog. The enduser is not affected by the problem but you end up with an critical event in the eventlog.
I found it interesting that the user id gets written into the eventlog and not the application pool ID. Also the error only occours when using the silverlight enabled create new site dialog.
I opened up a call with the Microsoft premier support and they could reproduce my error as well in their environments.
The support engineer added a defect to the bugtracking database and confirmed the following workaround:
- Connect to your DB Server where you host your SharePoint configuration database.
- Open the SQL Management studio
- Expand the SharePoint configuration database
- Navigate to programmability\StoredProcedures and select the stored procedure “dbo.proc_GetProductVersions”
- Right click the stored procedure and select properties
- Select permissions
- On the new popup screen, click Search, select [WSS_Content_Application_Pools] database role and click OK.
- On the first popup screen, select the role, check Execute permission and click OK.
Also you can shorten this steps by running the following SQL command:
GRANT EXECUTE ON OBJECT:dbo.proc_GetProductVersions TO [Domain\AppPoolUser]
Unfortunately I don’t know when Microsoft will implement a fix for this issue.