sql server reporting services: SQL 2000 Reporting Services on Production DB Server? -- sql server reporting services

Re: SQL 2000 Reporting Services on Production DB Server?

Norman Yuan
8/30/2007 9:03:34 AM

No, it does not REQUIRE VS2003 installed, unless you want to design report
on the RS server. Yes, .NET 1.1 is required, so as IIS. Please be aware, if
you install RS on a seperate server (with IIS running), you also need a full
SQL Server2000 license (i.e. you use need two SQL Server2000 licenses, one
for the production SQL Server, one for RS2000 on different computer).

[quoted text, click to view]

Re: SQL 2000 Reporting Services on Production DB Server?

Bruce L-C [MVP]
8/30/2007 11:01:33 AM

You DO NOT need to install vs studio 2003 on the server and you should not.
That is required for designing reports which you should do at your
workstation not on the production server. Then you deploy from VS to the
server.

You do need IIS and 1.1 framework. Neither of which is really a problem.
However, I personally would not install RS 2000 on a production database
server. The reason is that it had some problems with rendering pdf and excel
that could freeze the server. I periodically had to reboot with RS 2000.
That problem has totally disappeared with RS 2005.

I very strongly recommend that you do not start with RS 2000. Go right to RS
2005. If your database needs to stay at 2000 that is fine. RS 2005 can have
its object cache/metadata databases created on SQL 2000. You just need to
have a SQL 2005 license. If you install RS on another server you have to
have another SQL Server license there (you need a license wherever RS is
installed). So really look into getting a 2005 license and using RS 2005.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.