I have a user who was had access to a particulare ssrs report, now he does not he receives the following error.
• Logon failed. (rsLogonFailed)
o For more information about this error navigate to the report server on the local server machine, or enable remote errors
The permissions granted to user 'MSG\mspears' are insufficient for performing this operation. (rsAccessDenied) Get Online Help
How can I add the report back for this user to view? This is on SQL server 2005