Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Install MS SQL Server 2000 Report Services Expand / Collapse
Author
Message
Posted Wednesday, July 31, 2013 2:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 12:26 AM
Points: 47, Visits: 180
Hi Guys

I need urgent help. I'm trying to install MS SQL Server 2000 Report Services on our DR ISS server, but the install does not give me that option to install reporting services and configure it. The only options available under feature selection are, Client components, administration tools and documents and samples. On the other hand the System Prerequisites Check has the the following exclamation marks, ASP.NET is not installed or is not registered with your Web Server and the other is Visual Studio.NET 2003 is not installed.

The server is a web server and has other sites configured and running on the same server and yes ASP.NET is installed and configured, i double checked it.
Post #1479348
Posted Tuesday, August 06, 2013 9:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:21 AM
Points: 2,797, Visits: 3,079
Reporting Services for SQL 2000 was a separate component with its own install process. It will also need IIS installed for it to work.

Best of luck in finding the SSRS 2000 install media.



Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 25 March 2014: now over 28,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1481396
Posted Wednesday, August 07, 2013 4:02 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 8:05 AM
Points: 681, Visits: 1,338
I agree. SQL Server 2000 ended mainstream support years ago. Is the data source you are reporting on based on SQL Server 2000 still? You would be better served trying to implement a more current, documented and supported version, like SQL Server 2008 R2 or higher.

On another note doing a quick search on Microsoft's download site it looks like you cannot even get SQL Server 2000 Reporting Services any longer, just service packs, security patches and the eval edition of reporting services which I am going to assume it time limited.


Joie Andrew
"Since 1982"
Post #1481766
Posted Wednesday, August 07, 2013 4:16 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 12:26 AM
Points: 47, Visits: 180
Hi Joie Andrew and Ed

I have extensive search but looks like reporting 2000 is not longer supported, i was also not successful in installing it as it kept complaining about the prerequisites not met while I'm sure they are all installed for example .NET. Nevertheless i have decided to upgrade to sql server 2008 and reporting 2008 which I'm more familiar with and comfortable to work with. 2000 is now a nightmare.

Thanks guys
Post #1481773
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse