January 23, 2007 at 6:45 am
Hi,
I've managed to fudge my way through a few installations and have things working at a couple of sites, but am having difficulty getting security set up at one site. Can anybody recommend a good book on SQL Server 2005 Reporting Services which will detail installation and configuration with emphasis on the IIS and Security stuff?
Thanks.
January 23, 2007 at 7:41 am
Frank,
The book that i've found to be pretty useful in typical applications of SQL Server 2005 Reporting Services is "Microsoft SQL Server 2005 Reporting Services 2005 by Brian Larson " ISBN 0-07-226239-7. It takes you step by step so it's pretty easy to follow. You can find it on Amazon.com or the local book store pretty easy from what i've found. I hope that helps.
What problems are you having with security? Perhaps i can help.
Jason
January 23, 2007 at 8:15 am
Hi Jason,
thanks for responding. I've been considering the book you mentioned and Professional SQL Server 2005 Reporting Services by Paul Turley and one or two others I found on Amazon (here in Trinidad the book stores are rather sparse with SQL Server books).
The problem I am having is that the administrator can run the reports, but two other users were unable to (even though we gave them administrative rights). One was seeing the RS home page, but was not seeing the folder that I created my reports in and the other was not getting access to the RS home page. I solved the second user's problem by adding their user id in SQL Server to the ReportServer and ReportServerTempDB, but doing this for the first user did not work.
Basically, what needs to be done to let a user run the reports I created? I thought that I shouldn't have to make users administrators and that I probably shouldn't have to add the users in SQL Server, but I'm really unsure.
Thanks,
Frank.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply