error while upgrading sql reporting service sp2

[sugu]

Hi,

I'm trying to install Reporting service sp 2.



My sql 2000 server is installed another system .This one serves as domain with win server 2003.



I'm trying to upgrade to rs sp 2 in another system which is serving as web server(win web server 2003).RS sp 1 is already installed.



Recently, i upgraded the sql server 2000 service pack from 3a to 4 before trying to upgrade to RS sp 2.



Then tried to install the RS SP2 in the web server. But i have this error msg : SQL setup failed to connect to the db service for sql server configuration. I dont have MS VS.NET installed but have the .NET framework installed n running. I tried to disable the Terminal Service...but doesnt solve the problem.



when i tried to run rskeymgmt it says that it is not recognised as an internal or external command, operable program or batch file.



Pls i need to resolve this asap.

Thanks!



su

 

[DrSql]

Sugu..
Sorry I am not able to provide you any help, I am currenly thinking about rolling so I would appreaciate if you can provide with some deatils how you approced the Reportinmg service intsalls. Any good documenatins, links that I can gather some info also any tips and issues that you come across.

Dr.Sql
Good Luck.

 

[sugu]

Hi

The following is the from the log file.

[Info] Microsoft SQL Server 2000 Reporting Services SP2 Setup beginning at Tue Sep 27 19:25:50 2005
[Info] we are running from --> d:\d9c0bcb38e469dd2741d\sp2setup.exe
[Info] Application version number is --> 2000.80.1038.0
[Info] MsiQueryProductState for {7C93251A-BFB4-4EB8-A57C-81B875BB12E4} returned -1
[Info] MsiQueryProductState for {B19FEFE7-069D-4FC4-8FDF-19661EAB6CE4} returned 5
[Info] Product {B19FEFE7-069D-4FC4-8FDF-19661EAB6CE4} is installed!
[Info] {B19FEFE7-069D-4FC4-8FDF-19661EAB6CE4} has an LCID of 1033.
[Info] Server_Components feature installed. Adding to the reinstall list.
[Info] RS_Server feature installed. Adding to the reinstall list.
[Info] RS_Manager feature installed. Adding to the reinstall list.
[Info] Client_Components feature installed. Adding to the reinstall list.
[Info] RS_Designer feature NOT installed.
[Info] RS_Admin_Tools feature installed. Adding to the reinstall list.
[Info] fWin9X = FALSE, fAdmin = TRUE
[Resource] Minimum Msi Value = 200
[Info] No upgrade is necessary. System version meets minimum requirements
[Info] Windows Installer is the correct version
[Resource Error] We were unable to load the resource: IDS_PROPERTIES.
[Info] Setting Internal UI level to BASIC...
[Info] Turning on logging for the patch...
[Info] MSP Logging turned on. Logging to C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\Rssp2MSP5.log
[Info] Patch is a MINPATCH (small or minor update patch) so using default command line 'RUNFROMSP2SETUP=TRUE REINSTALLMODE=romus REINSTALL=Server_Components,RS_Server,RS_Manager,Client_Components,RS_Admin_Tools,'
[Info] Calling MsiApplyPatch with szPatchPackage = d:\d9c0bcb38e469dd2741d\sp2patch.msp
and szInstallPackage = {null} and eInstallType = INSTALLTYPE_DEFAULT
and szCommandLine = RUNFROMSP2SETUP=TRUE REINSTALLMODE=romus REINSTALL=Server_Components,RS_Server,RS_Manager,Client_Components,RS_Admin_Tools,

why couldnt i install the rs sp2?

-su