• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • 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

mark
0
manelson05
Asked:
manelson05
1 Solution
 
SThayaCommented:
Hi,

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


http://odetocode.com/articles/215.aspx
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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