Results 1 to 4 of 4

Thread: Sql 2000 Sp2

  1. #1
    Join Date
    Aug 2002
    Location
    South Wales, UK
    Posts
    2

    Unhappy Unanswered: Sql 2000 Sp2

    We have just rebuilt our server, upon reinstalling SQL Server 2000, we also added service packs 1 & 2. Although when you query the version is shows 8.00.384 (which is SP1!), but should actually be 8.00.534 (SP2).

    Upon attempting to reinstall SP2, the setup fails with the following....

    Setup Initialisation Error, Access Denied.

    Does any body have a solution to this problem other than completely uninstalling and reinstalling SQL 2000, as the different system build numbers are preventing us from restoring our MASTER and MSDB databases to the rebuilt server.

  2. #2
    Join Date
    Aug 2002
    Posts
    20
    Hi DamianHill,

    It depends how set up SQL server and/or on your “user” rights. But my guess is that it’s our user rights that stops you. If you run your sql server in mixed mode then you can choice sql authentication when you run sp2, else you have to be using the administrator account.

    I hope this fix your problem.
    /Mats

  3. #3
    Join Date
    Jul 2002
    Posts
    4
    also make sure there's no connection to the database... this can be done by following the install instructions (disabling services) of this service pack

  4. #4
    Join Date
    Aug 2002
    Location
    South Wales, UK
    Posts
    2

    Talking

    Originally posted by iis5_rulez
    also make sure there's no connection to the database... this can be done by following the install instructions (disabling services) of this service pack
    Hi Guys,

    Thanks for the help. The problem has now been resolved and the server is working at SP2 again. The problem was caused by a failed install of Sp2, which left files in %TEMP%. After removing these files from the %TEMP% folder, the service pack reinstalled fine, and is now showing the correct build.

    Thanx

    Damian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •