Unknown SQL Exception from SharePoint?

Question

Out of nowhere, we started to get an error on our SharePoint logs:

Unknown SQL Exception 297 occurred. Additional error information from SQL Server is included below.  The user does not have permission to perform this action.

I read that you had to grant View Server State to the main account in SQL, but that didn't work.  I hate having any exceptions in a logfile, especially when you're trying to track down others.  Can someone offer some advice on what I can look at for this error?  It's flooding my logfiles!!

Thanks in advance!

Answer 1

Hello,

maybe those topics can hekp you

http://social.technet.microsoft.com/forums/en-us/sharepoint2010setup/thread/3215D0B3-1BEC-4AEE-844D-DECDE9DEA1D8

http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/ec369448-e6da-426d-9765-eea4b2637638
http://davemcmahon81.wordpress.com/2011/08/21/%E2%80%9Cuser-does-not-have-permission-to-perform-this-action%E2%80%9D/

---

Best regards, Christopher.
Blog | Mail
Please remember to click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.

Answer 2

Despite what the SQL guys had told me, the VIEW SERVER STATE was NOT granted to my Farm account.  Once we granted this, the error went away.  This whole post could have probably have been prevented had we verified it was enabled the first time.... my fault - but it's fixed... thanks