|
As always you must have a working backup before you proceed. Put the Premium Technology CD in your CD player and have a look at the first screenshot.
Choose 'Install Microsoft SQL Server 2000'. Note that if you run this from SBS 2003 Premium Technologies SP1 integrated media the extract window will show, if you install SQL 2000 from Gold media the SQL installer will start immediately.
Click continue and ignore this warning.
Click next to continue setup
Be sure that local computer is selected and click next.
Select to 'Create a new instance of SQL Server, or install Client Tools'.
Fill in your name and company name if it does appear in this window.
Accept the EULA and click Yes.
Choose 'Server and Client Tools' and click Next
Uncheck 'Default' and give the instance a name.
You can choose to put the databases on another partition or drive. In most cases you should do that.
Choose 'Use the Local System account'. In most cases this is the easiest way to setup a new instance. Only in situations where security is a concern you would create a special account that is only used to start the new instance, for example a database that is the back end of a web server but this is outside of the scope of this article.
Depending on your needs you will set the database to 'Mixed Mode' or 'Windows Authentication'. In our case we choose Mix Mode because we want to use this database in a web application. You must define a 'sa' password. Be sure to make this a very complex and long password because the 'sa' account has access to everything in this new instance. If you are going to use this instance and its databases in a web application you should never use the 'sa' account in your connection string. Instead of using the 'sa' account you should create a new account that is 'dbowner' of only that database you are going to use.
Click finish to complete setup.
|