Solved

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

Posted on 2011-09-21
2
268 Views
Last Modified: 2012-05-12
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
Comment
Question by:manelson05
2 Comments
 
LVL 8

Expert Comment

by:venk_r
Comment Utility
0
 
LVL 11

Accepted Solution

by:
SThaya earned 500 total points
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video discusses moving either the default database or any database to a new volume.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now