This article explains how to replace the currently installed K2.net™ 2003 databases with clean databases.

The K2.net™ 2003 installer application may be used to remove the currently installed K2.net™ 2003 databases (K2 and K2Log), and replace them with new, clean databases.

Note: This procedure ONLY works with Service Pack 1a of K2.net™ 2003 Server. Do not attempt this procedure if you are not running Service Pack 1a.
1.  On the K2.net™ 2003 Server machine, open the "Add or Remove Programs" application from the Control Panel. Select "K2.net 2003 Service Pack 1a" from the "Currently Installed Programs" list and click the "Change" button.
2.  The program maintenance screen will be displayed – click on the ‘Modify’ option as indicated:
 
 
3.  On the "Custom Setup" screen, de-select the "K2.net 2003 Database" and "K2.net 2003 Log Database" components, as indicated:
 
 
4.  On the "K2.net 2003 Server Database Information" screens, enter the details of your existing K2.net™ 2003 databases (K2 and K2Log). Note: You must use the same settings as were specified during the initial installation of K2.net™ 2003 (the same server name and authentication settings), for example:
 
 
5.  

Continue with the rest installation process as normal.

Note: Remember to keep your K2.net License Key nearby. Alternatively, during the installation process, the license key will be displayed on the K2.net 2003 Server License Key Information screen. Make a note of this K2.net license key, as you will need to enter it again when reinstalling the databases.
6.  Using a SQL script or the Microsoft® SQL Server Enterprise Manager, delete the K2 and K2Log databases from the specified SQL Server.
7.  Once you have deleted the existing databases, run the "Add or Remove Programs" application from the Control Panel again. Select "K2.net 2003 Service Pack 1a" from the "Currently Installed Programs" list and click the "Change" button.
8.  Once the "Custom Setup" screen has been reached, select the "K2.net 2003 Database" and "K2.net 2003 Log Database" components as indicated:
 
 
9.  

On the "K2.net 2003 Server Database Information" screens, enter the details for your new K2.net™ 2003 databases (K2 and K2Log).

Note: Use the same settings that were specified during the initial installation of K2.net™ 2003 (the same server name and authentication settings), for example:
 
10.  Continue with the installation process as normal. The new (clean) K2 and K2Log databases will be created in the specified SQL server once the installation wizard has completed.