• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

How Do I create SSRS subscription for a user in SQL 2005

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

Thank you

1 Solution
SThayaTechnical MAnagerCommented:

Please check the  Role Assignment  in report server wheather the given user has  sufficient access..
 .. set as "Content Manager" as Role

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now