Hi collierd
You will need to setup a named instance of sql server. Follwo these instructions from BOL and then DTS the data between the default instance and named instance.
How to install a named instance of SQL Server 2000 (Setup)
You can install a named instance of Microsoft® SQL Server™ 2000 the first time you run SQL Server Setup or later after the default instance is installed. For each additional named instance you want to install, follow this procedure.
Note If you have a SQL Server 7.0 installation on your computer, the installation remains intact during the installation of a named instance of SQL Server 2000. A default instance of SQL Server 2000 will overwrite a SQL Server 7.0 installation (as the previous default installation), but a named instance does not overwrite SQL Server 7.0.
To install a named instance of SQL Server 2000
Insert the SQL Server 2000 compact disc in your CD-ROM drive. If the compact disc does not autorun, double-click Autorun.exe in the root directory of the compact disc.
Select SQL Server 2000 Components.
If you are running Microsoft Windows® 95, Install Common Controls Library Update.
Select Install Database Server and setup prepares the SQL Server Installation Wizard. At the Welcome screen, click Next. In the Computer Name dialog box, Local Computer is the default option, and the local computer name appears in the edit box. Click Next.
In the Installation Selection dialog box, click Create a new instance of SQL Server, or install Client Tools, and then click Next.
If this is the first SQL Server 2000 installation on your computer, follow the directions on the User Information, Software License Agreement, and related screens.
If an installation of SQL Server 2000 exists on your computer, these screens are omitted.
In the Installation Definition dialog box, click Server and Client Tools, and then click Next.
In the Instance Name dialog box, clear the Default check box, and type a name for the new named instance, and then click Next.
Note If you have an existing default installation (either SQL Server 7.0 or 2000), the Default check box is not available.
If you have typed an instance name, and later return to the Instance Name dialog box to change the name before completing setup, you can do so. However, a workaround is necessary to edit the instance name box, which will be unavailable after clicking Back to get to this dialog box. Select the Default checkbox, then immediately clear it, and you will be able to edit the instance name.
For more information about instance names, click Help.
In the Setup Type dialog box, select Typical, Minimum, or Custom, and then click Next.
If you want to select subcomponents or change character set, network libraries, or other settings, click Custom.
In the Service Accounts dialog box, accept the default settings, enter your domain password, and then click Next.
For information about services account options, see Services Accounts.
In the Authentication Mode dialog box, accept the default setting, and click Next.
To use Mixed Mode authentication, see Authentication Modes.
When you are finished specifying options, click Next in the Start Copying Files dialog box.
In the Choose Licensing Mode dialog box, make selections according to your license agreement, and click Continue to begin the installation.
Click Help for information about licensing, or see your system administrator.
In the Setup Complete dialog box, click Yes, I want to restart my computer now, and then click Finish.
Hope this helps
John
