SQL Server 2005 Error "The user does not have permission to perform this action" - clears up after r

Posted by Sylvia on Stack Overflow See other posts from Stack Overflow or by Sylvia
Published on 2010-04-21T18:19:52Z Indexed on 2010/04/21 18:23 UTC
Read the original article Hit count: 353

Filed under:

We're getting the error "The user does not have permission to perform this action" during times of heavy load (regularly, when a trim job occurs). The error clears up when the service accessing sql server is restarted, so it's obviously not a real permissions problems.

There's a possibility that the problem is occurring when we're trying to query dm_tran_active_transactions and sys.dm_tran_session_transactions.

Any ideas of good places to start looking?

thanks for any insights...

© Stack Overflow or respective owner

Related posts about sql-server-2005