EXECUTE permission denied on SharePoint Config DB

Whilst troubleshooting a SharePoint 2010 throttling issue earlier this week, I stumbled across some totally unrelated SQL exceptions in the Windows Event log:

Insufficient SQL database permissions for user ‘Name: mydomain\domain_user SID: S-1-5-21-348440682-330175067-1304115618-117920 ImpersonationLevel: Impersonation’ in database ‘Config_DB_SQL_SharePoint’on SQL Server instance ‘SQL_SharePoint’. Additional error information from SQL Server is included below.

The EXECUTE permission was denied on the object ‘proc_GetProductVersions’, database ‘Config_DB_SQL_SharePoint’, schema ‘dbo’

It seems that this exception is generated when you click on the ‘Create Site’ option and Silverlight kicks-in (even though it doesn’t appear to be denying me access to anything)

 

The Farm I was troubleshooting against is patched to ‘February 2012 CU’, so I cannot confirm at this stage whether this has been fixed in a more recent update. If you are precious about what is appearing in your Windows Event Logs and want to mitigate against the ‘red-herrings’, you can apply the following SQL fix (but be extra careful as this is against the ‘Config_DB’)

  • Expand your SharePoint Configuration database and navigate to ‘proc_GetProductVersions’ under Stored Procedures
  • Right-click proc_GetProductVersions’ and choose Permissions
  • Select the Search button and browse for ‘WSS_Content_Application_Pools’
  • Provide ‘Execute’ permissions for ‘WSS_Content_Application_Pools’
  • Click OK

     

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s