Jump to content


anyweb

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

Recommended Posts

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.

 

sql_upgrade_advisor.JPG

 

 

When the wizard appears click next

 

sql_wizard.JPG

 

accept the license aggreement

 

sql_license.JPG

 

enter/verify your registration information

 

sql_info.JPG

 

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

 

sql_features.JPG

 

choose install to install the SQL Upgrade Advisor

 

sql_ua_install.JPG

 

once done click on Finish

 

sql_ua_finish.JPG

 

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

 

sql_ua_start.JPG

 

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

 

sql_ua_launch.JPG

 

This will launch another wizard

 

sql_advisor.JPG

 

click next to continue

 

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

 

sql_advisor_components.JPG

 

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

 

sql_advisor_connect.JPG

 

click next when prompted for what databases to analyze

 

if you get an error about not finding the notification services

 

sql_advisor_error.JPG

 

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

 

sql_advisor_ns.JPG

 

 

click next for the DTS parameters

 

sql_dts.JPG

 

view the confirmation

 

sql_ua_confirm.JPG

 

and click Run to start...

 

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

 

sql_done.JPG

 

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

 

sql_ua_report.JPG

Share this post


Link to post
Share on other sites

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

 

sql_server_install.JPG

 

accept the EULA

 

sql_server_eula.JPG

 

After it has installed the prerequisites click next

 

sql_server_checks.JPG

 

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

 

sql_server_welcome.JPG

 

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

 

sql_server_done.JPG

 

after this you will see your registration info

 

sql_server_registration.JPG

 

clkicking next will allow you to decide what services to install

 

sql_server_services.JPG

 

I selected them all and clicked next

 

sql_server_services_selected.JPG

 

leave the default instance at it's default settings

 

sql_server_default_instance.JPG

 

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

 

sql_server_found.JPG

 

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

 

sql_server_details.JPG

 

 

go with the default authentication settings

 

sql_server_auth.JPG

 

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

 

sql_server_password.JPG

 

for the remaining serivices use the local system account

 

sql_server_sqlbrowser.JPG

 

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

 

sql_server_analysis_collation.JPG

 

use default configuration settings for the Report Server

 

sql_server_report_server.JPG

 

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

 

sql_server_report_server_auto.JPG

 

review the summary and click Install

 

sql_server_summary.JPG

 

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

 

sql_server_setup_complete.JPG

 

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

 

sql_client_install.JPG

 

When the wizard appears click next

 

wizard_install.JPG

wizard_lic.JPG

wizard_inf.JPG

wizard_features.JPG

wizard_start_install.JPG

wizard_done.JPG

Share this post


Link to post
Share on other sites

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

 

sql_sp2.JPG

 

accept the aggreement

 

sql_sp2_eula.JPG

 

leave the feature selection as it is

 

sql_sp2_feature_selection.JPG

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

 

sql_sp2_authentication.JPG

 

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

 

sql_sp2_error_reports.JPG

 

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

 

sql_sp2_processes.JPG

 

now we are ready to install !

 

sql_sp2_readty_to_install.JPG

 

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

 

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

 

 

reboot.JPG

 

click ok and then Next,

 

next.JPG

 

and you'll see the installation summary,

 

summary.JPG

 

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

 

additional.JPG

 

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

 

vista_privs.JPG

 

please Digg this if you found it useful

 

 

cheers

anyweb

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...