Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
 Posted - 2009-04-27 : 01:48:09
|
| Hi all, We have a SQL 2005 server here on which we would like to install RS. I haven't done much RS admin and I need to know what we need from the network admins to get this happening (things are generally pretty well locked down here). Our requirements are basically to deliver the reports via IIS or email. I need to tell the network admins what work is required on the active directory side to get it working:- does the server need any specific configuration in AD?- do we need to run the RS and/or IIS service under a domain account?thanks in advance for any assistance,Cheers,Tim |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2009-04-29 : 06:55:48
|
| Hi Tim,If possible I would recommend installing RS on a different sever as it can be pretty resource intensive depending on usage.You will have to specify a user to run the service which runs the reporting server. This could be an AD user you have set up or I'm pretty sure you can use a local account.Users who will need to access the reports will require access to the SQLServer2005MSSQLUser group. The way I've done this is I set up an AD security group which includes the users who will be accessing the reports. I then made this group a member of the SQL group I mentioned on the server.Hope this helps. |
 |
|
|
|
|
|
Requirements for setting up RS2005 on existing box