Saravana's Blog

SQL Server 2000 Reporting Services Installation in 2003 server

Today I tried installing Reporting services in my machine. After two attempts, I installed successfully. These are my learning's from this installation...

1. SQL Server Reporting services require SQL Server SP3a  for SQL Server 2000. Install that first. You can dowload this from the following location.

http://www.microsoft.com/sql/downloads/2000/sp3.asp

After installing, do a reboot.

2. If you have installed whidbey or longhorn bits, then you need do some registry hack. Otherwise Reporting services will give an error “ASP.NET v1.1 not Installed” so it wont install server components. This error is coming because when you install whidbey, ASP.NET version is mapped to 2.0*.. However reporting services requires 1.1 only.. I dont why such requirement is there as 1.x ASP.NET pages will work in 2.0 version also..

To avoid this just change this reqistry setting,

\\HKLM\SOFTWARE\Microsoft\ASP.NET\RootVer] = "1.1.4322.573"

For more details, refer this blog

3. If you provide service account for running reporting service, then you will get a error “install an hotfix XXXX if you want to run this service in NT Service account”.. To avoid this give any domain account credentials.

4. After you install reporting service, install reporting service service pack1. you can download it from here,

http://www.microsoft.com/downloads/details.aspx?FamilyId=580FEBF7-2972-40E7-BCCF-6CD90AC2F464&displaylang=en