April 11, 2008 at 3:04 pm
I'm even less of a newbie on this. Experienced DBA, but I suck at SRS stuff. I had a contractor come in and write a report. He has SA-level access to everything on the SQL 2005 server with SRS installed on it. He left. New report writers need to go in and fix this report for me. Problem, they aren't DBAs so I can't give them SA-level access. However, I don't know enough to spit on how to give them access to register the Reporting Services service in SMS, much less how to get them access to the report. What I've done so far is, right click on the name of the registered reporting services service in SMS, selected properties, then permissons, and I've added their Windows Accounts, and checked System Admins for both of them. When they try to register the reporting service service in their SMS, it says they don't have sufficient rights. What rights do i need to give these guys without making them SA on the database engine?
Thanks,
Lezza
April 13, 2008 at 12:41 pm
Not sure that they would need SSMS for dealing with RS. I am a godlike admin and haven't been able to connect using SSMS to RS but realized it probably didn't matter.
All of our report stuff happens through report manager on the RS server.
Usually \\servername\reports.
There you can grant them the publish permission in RS.
They would change the reports using BIDS and then promote. Our just import the RDL using reportmanager.
Susan
April 14, 2008 at 5:19 am
I've been a SQL DBA since 1998 and a Report Developer since 2004 with the Add-on for SQL 2000 and went to 2005 when it cam out. I have ALWAYS developed my RDL's in Visual Studio, then deployed to the Report Server. You can go through SQL Server Reporting Services Report Manager to give them permissions to publish (deploy). The only thing I could see using the Management Studio for is looking through the tables...and Visual Studio contains a similar tool.
If you don't have some type of source control in which the contractor left the source of the report, then the people modifying the report can go through Report Manager, then go through the properties tab and save the RDL somewhere. Then they can use Visual Studio to work on the report.
Good Luck!
-- Al
April 14, 2008 at 2:49 pm
Here might be a good place to start...
Managing Permissions and Security for Reporting Services
Honestly if they, as a SSRS developer, don't know how/where to set up security, they probably are brand new or aren't worth the wage you're paying them...
...Sorry...it's Monday..
B-)
Ben Sullins
bensullins.com
Beer is my primary key...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply