Jump to content


Install SQL server 2000 standard edition

1 reply to this topic

#1 t-zwck



  • Super Moderators
  • 759 posts
  • 9731 thanks

Posted 10 August 2009 - 02:39 PM

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

Attached File  1post-1-1203544156.jpg   58.97K   30 downloads

choose the first option which is to install a database server

Attached File  2post-1-1203544257.jpg   61.41K   29 downloads

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)

Attached File  3post-1-1203544420.jpg   19.61K   27 downloads


SQL Server 2000


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

Attached File  4post-1-1203544578.jpg   23.68K   25 downloads

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

Attached File  5post-1-1203544659.jpg   30.58K   26 downloads

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

Attached File  6post-1-1203544775.jpg   31.45K   25 downloads

edit the details if appropriate

Attached File  7post-1-1203544842.jpg   24.17K   25 downloads

click yes to accept the license

Attached File  8post-1-1203544898.jpg   51.23K   25 downloads

accept the default of server and client tools and click next

Attached File  9post-1-1203545136.jpg   28.94K   25 downloads

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

Attached File  10post-1-1203545306.jpg   31.88K   25 downloads

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

Attached File  11post-1-1203545478.jpg   33.37K   25 downloads

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

Attached File  12post-1-1203545823.jpg   25.72K   25 downloads

we leave the authentication mode as default

Attached File  13post-1-1203545876.jpg   21.22K   25 downloads

and then we watch as it starts to copy files

Attached File  14post-1-1203545932.jpg   24.55K   25 downloads

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

Attached File  15post-1-1203546035.jpg   27.45K   25 downloads

and then it goes off and installs SQL server

Attached File  16post-1-1203546141.jpg   5.81K   25 downloads

after a while it's all done

Attached File  17post-1-1203546381.jpg   21.06K   25 downloads

Install SP3

so now we have to install SP3 that it mentioned earlier.. so let's http://www.microsoft.com/downloads/details.aspx?familyid=90dcd52c-0488-4e46-afbf-acace5369fa3&displaylang=en
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

Attached File  18post-1-1203547024.jpg   23.91K   25 downloads

click next and yes  to the license agreement

Attached File  19post-1-1203547093.jpg   52.97K   25 downloads

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

Attached File  20post-1-1203547171.jpg   32.7K   25 downloads

choose Windows Authentication on the next screen

Attached File  21post-1-1203623354.jpg   28.64K   25 downloads

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

Attached File  22post-1-1203547314.jpg   24.97K   25 downloads

select the upgrade microsoft search option and click continue

Attached File  23post-1-1203547474.jpg   42.92K   25 downloads

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

Attached File  24post-1-1203547533.jpg   36.42K   25 downloads

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

Attached File  25post-1-1203547641.jpg   24.32K   25 downloads

#2 t-zwck



  • Super Moderators
  • 759 posts
  • 9731 thanks

Posted 10 August 2009 - 02:41 PM

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.

Attached File  26post-1-1203548118.jpg   11.26K   20 downloads

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

Attached File  27post-1-1203548178.jpg   21.72K   19 downloads

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

Attached File  28post-1-1203548916.jpg   3.62K   19 downloads


Service pack 4 is available so please http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5

download it and install it

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users




Test Providers

Site Info

Go to top