Jump to content


anyweb

how can I install SQL server 2000 standard edition

Recommended Posts

This guide assumes you have Windows 2003 Server Sp1 installed and configured, if you don't know how to do that you could follow this RIS installation guide, which while not specific to this guide is good enough to get a server setup and installed.

 

Insert your SQL server 2000 standard edition cd (or download the ISO from MSDN) and mount it via daemon tools or similar, and click on SQL Server 2000 Components

 

welcome.JPG

 

choose the first option which is to install a database server

 

install_database_server.JPG

 

if you get a warning about the version of SQL you are using, make a note of what it says (we'll come back to that later)

 

please_apply_sp3.JPG

 

 

SQL Server 2000

Microsoft

 

--------------------------------------------------------------------------------

 

Issue Description:

 

SQL Server 2000 sp2 and below is not supported by this version of Windows. Please apply sp3 after installation of SQL Server 2000.

 

Click on continue and then next at the welcome wizard

 

welcome_wizard.JPG

 

choose local computer as we are installing SQL server on this server...

 

local_computer.JPG

 

stick with the defaults and go with 'create a new instance of SQL server'

 

new_instance_of_sql_server.JPG

 

edit the details if appropriate

 

user_information.JPG

 

click yes to accept the license

 

yes_to_license.JPG

 

accept the default of server and client tools and click next

 

server_and_client_tools.JPG

 

next we get to choose the instance name of the SQL server, let's leave it as default and click next.

 

default_instance.JPG

 

when prompted for setup type, leave it as typical and click next

 

default_setup_type.JPG

 

enter the password for your administrator account as we are going to use the domain user account

 

service_accounts.JPG

 

we leave the authentication mode as default

 

authentication_mode.JPG

 

and then we watch as it starts to copy files

 

start_copying_files.JPG

 

now you enter your licensing options..... in this example i chose 1000, you can click on help to find out more about your options.

 

per_seat_license.JPG

 

and then it goes off and installs SQL server

 

installing.JPG

 

after a while it's all done

 

done.JPG

 

Install SP3

 

so now we have to install SP3 that it mentioned earlier.. so let's download it

 

I chose sql2ksp3.exe from the list of 3 available options and once done, ran it, the file asked me where to install and i chose the default C:\sql2ksp3

 

once done, navigate to the folder and run setup.bat

 

you should see the Service pack 3 wizard

 

sp3_wizard.JPG

 

click next and yes to the license agreement

 

license_sp3.JPG

 

accept the defaults and click next for the instance name which we setup earlier

 

sp3_instance_name.JPG

 

choose Windows Authentication on the next screen

 

connect_to_network__sp_upgrade.JPG

 

accept the default security optionand when prompted for SA Password warning enter a password

 

password_warning.JPG

 

select the upgrade microsoft search option and click continue

 

upgrade_and_apply_sp3.JPG

 

choose your error reporting option and click ok to get things done.

 

error_reporting.JPG

 

and then its ready to begin copying files for the sp3 upgrade

 

ready_to_copy_files_for_sp3.JPG

 

you will eventually be informed that its time to backup your databases, but seeing as we didn't create any yet, there's no need.

 

backup.JPG

 

that's it, you've now installed SQL server 2000 and the required Service pack 3

 

done_sp3.JPG

 

a reboot at this point would be a nice idea to see your SQL server running in the system tray ;-)

 

sql_server_running.JPG

 

Service pack 4 is available so please download it and install it.

 

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