Reporting Services 2005 on a separate server

I recently installed an instance of SQL Server 2005 on a server that didn't have IIS. I received an error notification in the install logs that some components of SQL Server would not work. This lead me to wonder if Reporting Services 2005 truly can be installed on a separate server and run efficiently, so I pose the question to anyone out there who has had success doing so. Does IIS need to be installed on a server running an instance of SQL Server 2005 even if Reporting Services is not installed and is intended to be installed on a separate server? Any installation recommendations in installing RS 2005 on a separate server?Hi, some short answers, I hope they are suffiecient to your questions:

RS needs IIS to run. SQL Server 2005 does not.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Reporting Services

Can I have an instance of Reporting Services 2000 on the same server
as an instance of Reporting Services 2005? I have a client that has
two separate business units that share a server. One of which has the
budget and desire to upgrade, the other does not.
Thanks,
CarlaOn Apr 9, 9:33 pm, carlaaru...@.aol.com wrote:
> Can I have an instance of Reporting Services 2000 on the same server
> as an instance of Reporting Services 2005? I have a client that has
> two separate business units that share a server. One of which has the
> budget and desire to upgrade, the other does not.
> Thanks,
> Carla
The short answer is yes. This link should offer some insight.
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9bb9804ce4c84525/6881764e6f698961?lnk=st&q=reporting+services+2000+and+2005&rnum=19#6881764e6f698961
Regards,
Enrique Martinez
Sr. Software Consultant

Reporting Services

I installed SQL 2005 Tools and everything appears to work except setting up the Reporting Services server. I started with my local instance of SQL Server 2000, SP2. I found a comment that said I needed SP4. I installed with no errors but when I check the version number still says SP2 even after a reboot. I still couldn't use it as RS instance.

I can write reports but without the RS server I can't publish them.

I then installed SQL 2005 Express which works fine and attached the Adventurework databases. But I still cannot designate an RS server.

No report servers were found on the specified machine. Details: Invalid namespace.

I believe there should be a RS service running but there is not. I tried reinstalling from both the original Tools directory and the Add/Remove Programs. In both cases, it says everything is alread installed.

I installed SQL Express 2005 w/ all the extras and now I have a local instance of Reports Services.

reporting service database name

Hi,
Is there a way to find out(via table lookup) which database in an
given instance serves as a reporter database?.
More specifically, i need to report on some reprots and i do not want to
check every database in an instance to find out which one is used by
reporting services.
regards
-sarab> Is there a way to find out(via table lookup) which database in an
> given instance serves as a reporter database?.
> More specifically, i need to report on some reprots and i do not want to
> check every database in an instance to find out which one is used by
> reporting services.
In Query Analyzer, use
EXEC sp_who2
and check the DBName column in the row where the ProgramName coumn has value
'Report Server'. Use the lowest SPID value if there are more rows with
identical info (lower SPID=ServerProcess ID means earlier connection;
services should be faster when connectiong to SQL Server than regular
users).
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Additionally, you can use WMI to get all configuration settigs. Sample code
is in RS BOL, here is the MSDN link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_wmi_4aci.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:eRdZ%23l2sEHA.4040@.TK2MSFTNGP09.phx.gbl...
> > Is there a way to find out(via table lookup) which database in an
> > given instance serves as a reporter database?.
> >
> > More specifically, i need to report on some reprots and i do not want to
> > check every database in an instance to find out which one is used by
> > reporting services.
> In Query Analyzer, use
> EXEC sp_who2
> and check the DBName column in the row where the ProgramName coumn has
value
> 'Report Server'. Use the lowest SPID value if there are more rows with
> identical info (lower SPID=ServerProcess ID means earlier connection;
> services should be faster when connectiong to SQL Server than regular
> users).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>