Solved

Microsoft Reporting Services -- search fails ?

Posted on 2012-12-20
4
226 Views
Last Modified: 2013-01-25
Steps
 1. user logs into Windows XP machine
 2. goes to "Microsoft Reporting Services" internal website
 3. active directory allows user to run report
 4. user then does attached "test" text and clicks SEARCH
 5. search fails The permissions granted to user are insufficient for performing this operation ERROR

I did multiple tests, but nothing seems to fix this ERROR.
How can I fix ?

http://www.gotknowhow.com/articles/reportserver-permissions-granted-are-insufficient-for-performing-this-operation-rsaccessdenied
1.jpg
0
Comment
Question by:finance_teacher
  • 2
  • 2
4 Comments
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 38712707
login as SSRS  admin and make sure this user has Browse permissions in specific folder,
see more SSRS security:

http://technet.microsoft.com/en-us/library/ms157198(v=sql.90).aspx

BTW: what is your SSRS version\SP?

more
http://msdn.microsoft.com/en-us/library/dd255226.aspx
http://msdn.microsoft.com/en-us/library/dd255239.aspx
0
 

Author Comment

by:finance_teacher
ID: 38713363
http://website/ReportServer shows that I have Microsoft SQL Server Reporting Services Version 10.50.1790.0

Attached shows USERS already had Browse permissions

How can I fix ?
1.jpg
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38714804
try to add the specific user login: on some AD "everyone " is limited \not used.

if it does not work -- try to add this user as Content Manager Role
member, etc

and the most important - check if you have reports there
0
 

Author Comment

by:finance_teacher
ID: 38737324
still failed
0

Featured Post

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
the over sql construct is not supported 3 74
Sum Of Group In SSRS Report 18 94
SQL to find list of subscriptions for CSV reports. 5 15
performance query 4 32
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

809 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