Re: Installing Reporting Services



IBIS must be on the same physical machine as Reporting Services.

--
Cheers,
Dan
Lead Program Manager
SQL Server Manageability Platform Team
"This posting is provided "AS IS" with no warranties, and confers no rights"
"kascomm" <kascomm@xxxxxxxxxxxxxxxxx> wrote in message
news:DCB8F60F-54FC-4554-8C2F-1D2DC27E6528@xxxxxxxxxxxxxxxx
Hello, I'm a newbie here, so please forgive me if the following seems a
little simplistic. My question concerns the installation and setup of SQL
Server 2005 and Reporting Services.
Microsoft seem to advise against having a SQL Server and IIS on the same
machine, therefore I have a network where SQL server and IIS are on
separate
machines (in addition, the machines I have aren't that powerful, so this
makes sense anyway). However, during the SQL Server 2005 Installation, it
seems that IIS is required on the local SQL box in order to Install /
Configure / Run Reporting Services. This has left me confused, and I was
wondering if someone could address and clarify the following.

1) Does IIS need to be installed on the same machine as SQL server, in
order
to Install / Configure / Run Reporting Services (and am I correct in that
this goes against recommended good practice)?

2) Can IIS be installed on a separate machine to SQL Server (but on the
same
Network naturally), and still be able to Install / Configure / Run
Reporting
Services, and if so, how?

I am running Windows Server 2003 on all machines, and all boxes are on a
Network consisting of separate PCs for Domain Controller, SQL Server 2005,
and IIS 6.

If anyone has the time, this sort of leads in to 2 follow up questions.

3) I read somewhere IIS should be installed locally on a machine with
Visual
Studio 2005 installed in order to maximise the design features available?
Again, is this correct for Visual Studio 2005, or can IIS be installed on
a
separate box?

4) There seems to be a fair bit of comment, but little consensus from what
I
can find, on the best / most secure etc, way to have SQL Server
communicate
with IIS on separate boxes. Is there any definitive setup / method for
achieving this?

I appreciate I have covered quite a wide area with these questions, but
any
direct help, guidance, or references to material that may help, would be
greatly appreciated.
--
Many Thanks,

kascomm


.



Relevant Pages

  • Re: Internet Information Services in MCE
    ... Per user Group Policy Restrictions for XP Home and XP Pro ... However, I am able to run SQL Server Dev Edition on my work laptop, which is ... I've installed the IIS component but I'm not sure I have a good ... I'm trying to install SQL Server 2005, ...
    (microsoft.public.windows.mediacenter)
  • Re: SQL Server 2005 Express Adv. Edition Installation error 2259:Database table(s) update failed
    ... When I try to install SQL Server 2005 Express Adv. ... Steps to Reproduce:Either Windows install or manual install creates the error. ... Microsoft Internet Information Services (IIS) is either not installed or is disabled. ... some SQL Server features will not be available for installation. ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing SQL Server Express in Vista 64-bit
    ... it needs .Net 2.0 as a system requirement. ... "KB934162" is about installing Reporting Services. ... install SQL Server 2005 Express Edition, not the SQL Server 2005 Express ... It seems you are trying to install a x86 version of SQL Server 2005 Instance ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing SQL Server Express in Vista 64-bit
    ... "KB934162" is about installing Reporting Services. ... install SQL Server 2005 Express Edition, not the SQL Server 2005 Express ... Reporting Services, IIS, enable ASP.net, etc. I'm not too advanced. ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing SQL Server Express in Vista 64-bit
    ... "KB934162" is about installing Reporting Services. ... install SQL Server 2005 Express Edition, not the SQL Server 2005 Express ... It seems you are trying to install a x86 version of SQL Server 2005 Instance ... He suggests "cscript ...
    (microsoft.public.sqlserver.setup)