Re: Can't Install SP4 for SQL 2000 / Win2k3

Can you post the contents of c:\temp\1\sqlsp.out?
That should give us a clue to what went wrong

--
Vikram Vamshi
Database Engineer
Eclipsys Corporation
"hamm3r" <hammer@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:p6NFe.677$6%2.601@xxxxxxxxxxx
>I am attempting to update SQL 2000 Server (RTM) to SP4 on Windows 2003
>Server Standard w/ SP1
>
> After extracting SQL2000-KB884525-SP4-x86-ENU.EXE to C:\SQL2KSP4 and
> running setup.bat, the installation hangs at "Validating User. Please
> Wait" but then ceases (the install window disappears) with no
> errors/dialogue boxes.
>
> After reading up on this I changed the TEMP and TMP environmental
> variables so they have no spaces in them.
>
> The end of my sqlsp.log shows:
>
> 10:36:39 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:EMEXTSRV -n -d master -o
> "c:\temp\1\sqlsp.out" -Q"Exit(declare @ret int if (select count(*) from
> msdb.dbo.systargetservers) = 0 Set @ret=0 else Set @ret=403 Select
> et)" -E
> 10:36:39 Process Exit Code: (-100)
> 10:36:39 Error : While detecting required SP3 warnings.
> 10:36:39 End Action DialogShowSdUpgrade
> 10:36:39 End: ShowDialogs()
> 10:36:39 Action CleanUpInstall:
> 10:36:39 Installation Failed.
>
> And the C:\temp\1\sqlsp.out shows:
>
> Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery.
> See the SQL Server errorlog for more information.
>
> Since the database is not in production and since I have minimal SQL2000
> admin experience, I uninstalled SQL 2000 and deleted the C:\Program
> Files\SQL Server directory, rebooted, and reinstalled SQL 2000.
>
> Despite my efforts, the SP4 installation still fails in an identical
> fashion as prior to my reinstallation of SQL 2000.
>
> I have also tried installing SP3 and get the same errors.
>
> I can't seem to find any relevant solutions in the MSKB or in dejanews.Com
> on this.
>
> Can anybody help this lost soul?
>
> TIA!
>


.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • RE: Server cant be seen from the network
    ... Microsoft CSS Online Newsgroup Support ... I discovered that if I turned the SQL server ... NAT issues caused with the installation of the "full" SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)