1 reply to this topic

[t-zwck]

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

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

choose the first option which is to install a database server

 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)

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

Quote

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

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

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

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

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

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

edit the details if appropriate

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

click yes to accept the license

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

accept the default of server and client tools and click next

 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.

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

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

 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

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

we leave the authentication mode as default

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

and then we watch as it starts to copy files

 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.

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

and then it goes off and installs SQL server

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

after a while it's all done

 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

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

click next and yes  to the license agreement

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

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

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

choose Windows Authentication on the next screen

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

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

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

select the upgrade microsoft search option and click continue

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

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

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

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

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

[t-zwck]

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.

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

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

 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 ;-)

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

http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5

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