Solved

write permissions on the reporting server

Posted on 2009-05-06
6
185 Views
Last Modified: 2012-05-06
a few users need the write permission a the reporting server.they want to upload some report templates for the database X..how can I give these permissions on the sql server?
0
Comment
Question by:teodor76
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 24323275
wouldn't you add them as content managers (or contributors... I forget) on the security for the RS folder in question? From there they should be able to "upload a new report"
0
 

Author Comment

by:teodor76
ID: 24326511
sorry I didnt find where can I give permissions on the report server? please see attached..can you say me a detailed?  1 want to give them minumum permission right..
reportserver.JPG
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 29

Expert Comment

by:QPR
ID: 24330164
Do you need to give them permissions in the SQL Server for some reason?
How do your users view the reports? Do they use windows authetication or another method?
If Windows Authentication then open your resport server home page. navigate to the fodler that contains the reports you want them to add to. Go to "security" of that folder and add their windows account so that they can publish reports.
0
 

Author Comment

by:teodor76
ID: 24351926
we have a sql server 2005 that is installed database service and reporting service on..they use the database "test" on this server..they use windows authentication..how can I check that they have all privileges and necesssary configurations to create reports out of database "test"? do 1 need to perform some steps on this database "test"? 1 have gived them the permissions "content manager" on this reporting service and he says me that permission is working..are there other steps to do for this?
0
 
LVL 29

Assisted Solution

by:QPR
QPR earned 500 total points
ID: 24352166
Not that I am aware of. I have given users content manager permissions on the reporting website and they can add reports. I have not needed to also add permissions at the database level.

Unless... are you talking about the content for the report coming from the database? This is a completely different question. If they need to create a report which pulls info from database tables then they will need select permissions on the tables or views that they select from in the report.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

695 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