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 |
|
stumbling
Posting Yak Master
104 Posts |
 Posted - 2009-11-17 : 15:42:03
|
Hi AllThanks for your time.I have a few questions on Reporting services and basically understanding the installation of this.We run SQL 2005 with Mirroring and a Witness on 3 seperate servers, we are purchasing an app that uses reporting services something that we have not had before.Our IIS is on a seperate machine and i would like to have Reporting services on a seperate machine again.Can i install reporting services on a stand alone machine and point it to our SQL server and also to our IIS server?ORDo you have to install reporting services on a machine which has IIS i know from memory that when you do the install of sql if you do not have IIS on the machine you are installing it on then reporting services is not available so how do you get around this?Also to install i gather you can do it from the GUI off the SQL 2005 cd is that correct?Thanks for your time.Cheers |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-17 : 15:49:43
|
| install it to a web server -- a machine with iis already running. you can setup a dedicated server if you need...depends on the traffic your sites have and your RS site will have...meaning current and expected utilization.you can and should do the install from the CD, but you'll have to apply the SPs seperately. you'll want the same SP level as your SQL Server that RS will point to.Also you'll have to manually configure the rsconfig files.see here: http://msdn.microsoft.com/en-us/library/ms159114.aspx |
 |
|
|
stumbling
Posting Yak Master
104 Posts |
Posted - 2009-11-17 : 16:16:06
|
| Thanks for the response.I believe our Sysadmin will not allow it to be installed on the IIS box so does that mean we will need a new instance of IIS on the same box? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-17 : 16:50:50
|
| if not on existing iis box, then set it up on another one. but that may be overkill.it is definitely the right idea not to install it on sql box |
|
|
|
stumbling
Posting Yak Master
104 Posts |
Posted - 2009-11-17 : 17:40:04
|
| Thanks for the advice much appreciated. |
|
|
|
|
|
|
Installation Questions