August 26, 2014 at 12:13 pm
Our SharePoint system started getting the below error. This happened roughly the same time the SharePoint admin (with sysadmin permissions on the DB server) was setting permissions for a new application and he may have run a "script he found on the internet" but he can't produce this script to me. Has anyone seen something similar? What options do I need to use to trace what may have permissions denied?
Insufficient SQL database permissions for user 'Name: %DOMAINNAME%\%USERNAME% SID: S-1-5-21-138788938-496071466-2061804361-41832 ImpersonationLevel: None' in database 'SharePoint_Config_DB' on SQL Server instance '%INSTANCENAME%'. Additional error information from SQL Server is included below.
The SELECT permission was denied on the object 'sysobjects', database 'mssqlsystemresource', schema 'sys'.
The SELECT permission was denied on the object 'syscolumns', database 'mssqlsystemresource', schema 'sys'.
The SELECT permission was denied on the object 'stats', database 'mssqlsystemresource', schema 'sys'.
August 26, 2014 at 2:04 pm
Possibly this might have happened http://stackoverflow.com/questions/1473315/the-select-permission-was-denied-on-the-object-sysobjects-database-mssqlsyst
August 27, 2014 at 8:35 am
That didn't seem to be my problem, I can't find any denies on anything.
August 27, 2014 at 11:50 pm
This was removed by the editor as SPAM
August 28, 2014 at 4:16 pm
Sometimes when I have this issue, I start SQL Server Profiler and add the following events from the Errors and Warnings category: Exception and User Error Message. With these two you'll see the permission denied errors and they will occur close to or next to the statement that the account tried to execute but failed. If you don't see the SQL it executed, you'll need to add events from the Stored Procedures or TSQL event categories.
Hope that helps.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply