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.
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.
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
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.