Sql server 2000 reporting installation problem
-
Dear all, I need one help for installing sql server 2000 reporting services. Iam getting the following error while installing Sql server 2000 Reporting service software sp2. The Upgrade patch cannot be installed by the windows installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. verify that the program to be upgraded exists on your computer and that u have the correct upgrade patch. I have downloaded reporting service from Microsoft site. I have the following with these --Visual studio 2005 --Sql server 2000 with SP4 Please help me on this. How to install sql server 2000 reporting service. Regard's Veeresh
i want to join this group
-
Dear all, I need one help for installing sql server 2000 reporting services. Iam getting the following error while installing Sql server 2000 Reporting service software sp2. The Upgrade patch cannot be installed by the windows installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. verify that the program to be upgraded exists on your computer and that u have the correct upgrade patch. I have downloaded reporting service from Microsoft site. I have the following with these --Visual studio 2005 --Sql server 2000 with SP4 Please help me on this. How to install sql server 2000 reporting service. Regard's Veeresh
i want to join this group
Hi Veeresh, Please know that: 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 Hope this helps :)
Regards, John Adams ComponentOne LLC
-
Hi Veeresh, Please know that: 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 Hope this helps :)
Regards, John Adams ComponentOne LLC
Hi, Thanks a lot.I have one more thing.Can i use sql server 2000 reporting service with visual studio 2005.? Regard's Veeresh
i want to join this group