SQL Upgrade (to SP-4)
When you instlled your SQL server, you were probably warned that the version you installed was not compatabile
with Windows 2003 server until SQL server SP-3 is installed. - We'll do that now but we'll go one better. - We will
install SP-4 instead.
MS SQL Server 2000 SP-4 upgrade may sometimes be hard to find for download (it's free from Microsoft). - If you have
proglems locating it, we have a copy mirrored here:
SQL2000SP4.EXE. - This file is a little
under 70 mb. in size.
Before you start, make sure you delete any 'C:\SQL2KSP4' folder you may have. - This ensures you will be using
a fresh set of the upgrade files.
If your SQL server is running, stop it now.
After you have the SP-4 file downloaded, go to where you stored it and double-click on:
'sqlserver2000_servicepack4.EXE'.
The 'InstallShieldWizard' starts up and asks you where you want the SP-4 files extracted to. - Take the default and
click 'Next'.
The wizard will extract the files to the folder it specified. - Click 'Finish' to exit the wizard.
Note: The previous step DID NOT upgrade your SQL server. - It only prepared the files so you can
continue.
With Windows Explorer, open the 'C:\SQL2KSP4\ folder and double-click on 'setup.bat'.
At the 'Welcome' box, click on 'Next'.
Click 'Yes' to accept the License.
On the 'Instance Name' box, 'Default' will already be checked and you can't change it. - Just click
'Next' to continue.
In the 'Connect to Server' box, ensure 'The Windows account information I use to log on to my computer with
(Windows authentication' is selcted and click 'Next'.
In the 'SQL Server 2000 Service Pack 4 Setup' box, make sure 'Upgrade Microsoft Search and apply SQL Server 2000
SP4 (required).' is the only item checked and click 'Continue'.
For 'Error reporting', make sure 'Automatically send fatal error reports to Microsoft' - IS NOT - checked.
Now click on 'OK'.
Click 'Next' in the 'Start Copying Files' box.
You'll now be told that you should backup your 'master' and 'msdb' databases. - If this upgrade was on a clean instal,
this is not necessary.
You should re-boot your server now. - 'Yes, I want to restart my computer now' will be selected, click
'Finish' to exit the upgrade and re-boot your server.
When your server comes back up, you should see your SQL server running. - Congratulations! - You might want to bring up
a browser on the server and go to Microsoft to see if there are any updates. - Once you're sure you're server is up to
date, you can now move on to setting up the ASP.Net Login Control if you want.
Previous - SQL Install
|