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
choose the first option which is to install a database server
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)
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
choose local computer as we are installing SQL server on this server...
stick with the defaults and go with 'create a new instance of SQL server'
edit the details if appropriate
click yes to accept the license
accept the default of server and client tools and click next
next we get to choose the instance name of the SQL server, let's leave it as default and click next.
when prompted for setup type, leave it as typical and click next
enter the password for your administrator account as we are going to use the domain user account
we leave the authentication mode as default
and then we watch as it starts to copy files
now you enter your licensing options..... in this example i chose 1000, you can click on help to find out more about your options.
and then it goes off and installs SQL server
after a while it's all done
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
click next and yes to the license agreement
accept the defaults and click next for the instance name which we setup earlier
choose Windows Authentication on the next screen
accept the default security optionand when prompted for SA Password warning enter a password
select the upgrade microsoft search option and click continue
choose your error reporting option and click ok to get things done.
and then its ready to begin copying files for the sp3 upgrade
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.
that's it, you've now installed SQL server 2000 and the required Service pack 3
a reboot at this point would be a nice idea to see your SQL server running in the system tray ;-)
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
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
choose the first option which is to install a database server
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)
Click on continue and then next at the welcome wizard
choose local computer as we are installing SQL server on this server...
stick with the defaults and go with 'create a new instance of SQL server'
edit the details if appropriate
click yes to accept the license
accept the default of server and client tools and click next
next we get to choose the instance name of the SQL server, let's leave it as default and click next.
when prompted for setup type, leave it as typical and click next
enter the password for your administrator account as we are going to use the domain user account
we leave the authentication mode as default
and then we watch as it starts to copy files
now you enter your licensing options..... in this example i chose 1000, you can click on help to find out more about your options.
and then it goes off and installs SQL server
after a while it's all done
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
click next and yes to the license agreement
accept the defaults and click next for the instance name which we setup earlier
choose Windows Authentication on the next screen
accept the default security optionand when prompted for SA Password warning enter a password
select the upgrade microsoft search option and click continue
choose your error reporting option and click ok to get things done.
and then its ready to begin copying files for the sp3 upgrade
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.
that's it, you've now installed SQL server 2000 and the required Service pack 3
a reboot at this point would be a nice idea to see your SQL server running in the system tray ;-)
Service pack 4 is available so please download it and install it.
cheers
anyweb
Share this post
Link to post
Share on other sites