?
Solved

write permissions on the reporting server

Posted on 2009-05-06
6
Medium Priority
?
190 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 1500 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 1500 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

762 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