how can I upgrade SQL server 2000 to SQL server 2005 sp2

[anyweb]

Before starting this, make sure to backup all your SQL databases, any problems arising from doing this are your own responsibility, always test this on a test lab computer scenario before doing it in your business environment.

 

Download the following from Microsoft connect or your MSDN downloads area.

 

en_sql_2005_std_x86_dvd.iso

 

and

 

en_sql_server_2005_sp2_x86_cd.iso

 

burn them to DVD/CD or mount them using tools such as Daemon tools.

Step 1. Run the upgrade advisor to see what issues may need to be resolved

 

Start the SQL Server 2005 Standard edition DVD and select Install SQL upgrade Advisor from the list of options.

 

 

 

When the wizard appears click next

 

 

accept the license aggreement

 

 

enter/verify your registration information

 

 

click next when asked what features to install (go with the default)

 

 

choose install to install the SQL Upgrade Advisor

 

 

once done click on Finish

 

 

Now that it's installed, let's run it, so click on Start, All Programs, Microsoft SQL Server 2005, SQL Server 2005 Upgrade Advisor

 

 

When the Upgrade Advisor splashscreen opens, click on Launch Upgrade Advisor Analysis Wizard.

 

 

This will launch another wizard

 

 

click next to continue

 

choose the components you want to analyze (i selected all)

 

 

when asked how the Upgrade Advisor should connect go with the default settings unless you have changed them previously when installing SQL

 

 

click next when prompted for what databases to analyze

 

if you get an error about not finding the notification services

 

 

hit the back button three times and remove the checkmark from 'notification services' and continue again.

 

 

 

click next for the DTS parameters

 

 

view the confirmation

 

 

and click Run to start...

 

once done you can click on Launch Reprt to see the details

 

 

viewing the report will allow you to see what components to change before attempting the actual SQL upgrade.

 

[anyweb]

Step 2. Install the Server components, tools, Books online and samples

 

 

accept the EULA

 

 

After it has installed the prerequisites click next

 

 

when you see the welcome to the Microsoft SQL server install wizard click next

 

 

it will then carry out a series of 14 system configuration checks

 

 

after this you will see your registration info

 

 

clkicking next will allow you to decide what services to install

 

 

I selected them all and clicked next

 

 

leave the default instance at it's default settings

 

 

as we have SQL server 2000 already installed you'll get a message stating that it already found SQL Server Database Services 8.00.2039

 

 

place a checkmark in the empty box beside it and then for details click on the details tab

 

 

 

go with the default authentication settings

 

 

on the next screen enter your administrator password for the SQL Server Service,

 

 

for the remaining serivices use the local system account

 

 

leave the collation settings for service SQL Server Analysis Services as default

 

 

use default configuration settings for the Report Server

 

 

for the next screen leave the 'automatically send error reports' unchecked

 

 

review the summary and click Install

 

 

After quite some time you should hopefully see that Sql Server 2005 Setup has completed successfully. Make sure to scroll up and down to verify that all products listed have a status of 'setup finished'.

 

 

click next when ready, review the summary log for any errors reported during setup.

 

Summary.txt

 

Once done click on Finish and reboot the server

 

 

 

Step 3. Run the SQL Native Client Installation Wizard

 

Start the SQL 2005 client install program

 

 

When the wizard appears click next

 

[anyweb]

Step 4. install SQL 2005 Servvice pack 2

 

Burn the en_sql_server_2005_sp2_x86_cd.iso to CD or mount it using Daemon tools,

 

run the file called SQLServer2005SP2-KB921896-x86-ENU.exe

 

 

accept the aggreement

 

 

leave the feature selection as it is

 

and click next, leave the authentication as it is and continue

 

 

leve the error reporting settings as they are and click next...

 

 

we dont mind a reboot so lets click next (or if you want, close each process in task manager)

 

 

now we are ready to install !

 

 

time to go and make coffee, as this takes time.........

 

after a long time you'll be prompted to reboot...

 

 

 

click ok and then Next,

 

 

and you'll see the installation summary,

 

 

finally, you'll be presented with some additional information about what you've achieved

 

 

click finish and then you have the option to grant Windows Vista (and later) operating systems user rights to access SQL server (they are not automatically granted administrative privileges.)

 

in the sample below, i've given the user administrator full access to the available privileges.

 

obvioulsy change/add users that you feel need this access in your own environment

 

 

please Digg this if you found it useful

 

 

cheers

anyweb