We started seeing these strange event log entries on our web front ends.
“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’.”
I ran across this issue in our environment and found the info on what causes the error here, http://sharepointsoldiers.wordpress.com/2011/10/09/insufficient-database-permissions-proc_getproductversions-eventid-5214/#comment-30.
Thanks to the author for opening the case with MS and finding root cause.
I installed the April 2012 CU, in one of our test environments in preparation for an upcoming deployment and found that this issue is resolved by this CU. Not sure if it was fixed in the prior Feb CU or not, but this one fixed it for us.
