Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 2, 2016 5:11 AM
Points: 52, Visits: 215
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 6, 2013 9:13 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:19 PM
Points: 3,059, Visits: 3,780
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 2016, 2014, 2012, 2008 R2, 2008 and 2005. 29 Aug 2016: now over 38,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
Post #1481396
Posted Wednesday, August 7, 2013 4:02 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 18, 2016 4:15 PM
Points: 949, Visits: 1,884
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 7, 2013 4:16 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 2, 2016 5:11 AM
Points: 52, Visits: 215
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