Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

write permissions on the reporting server

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
teodor76
Asked:
teodor76
  • 3
  • 2
2 Solutions
 
QPRCommented:
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
 
teodor76Author Commented:
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
QPRCommented:
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
 
teodor76Author Commented:
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
 
QPRCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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