The information in this Article applies to:
Kaseya 2004 Enterprise Edition with MSDE (All versions)
Kaseya 2004 Small Business Edition (All versions)
Microsoft SQL Server Desktop Engine (MSDE, version 8)
Microsoft SQL Server 2000 (All versions)

Problem

Your Kaseya server currently runs with the Microsoft SQL Server Desktop Engine (MSDE), which contains a database instance named KVSAMSDE. You wish to upgrade your database from MSDE to a full Microsoft SQL Server 2000 installation without losing any information about the machines currently managed by the Kaseya server.

Resolution

Upgrade your Kaseya server to use Microsoft SQL Server 2000 instead of MSDE by reinstalling with the Kaseya 2004 Enterprise Edition without the MSDE bundle.

Use the following procedure to first save data from your current Kaseya server, then uninstall your current Kaseya server running with MSDE, and finally reinstall the Kaseya 2004 Enterprise Edition that uses SQL Server 2000:


  1. Download the Kaseya 2004 Enterprise Edition. Make sure you select the installation version that is intended for use with the Microsoft SQL Server 2000. This installation is approximately 11 MBytes, since it does not contain the MSDE installation.
  2. Log in to your current VSA server as a master administrator.
  3. Select the
    4. System tab.
  4. Click on the
    5. Configure function.
  5. Save a copy, e.g. in a text file such as c:\temp\backup\notes.txt, of the current address of the Kaseya server. This address is located on the
    6. Configure page in the field to the right of the label Change external name / IP address of Server:.
  6. Save a copy, e.g. also in c:\temp\backup\notes.txt, of the current port number of the Kaseya server. This port number is located on the
    7. Configure page in the field to the right of the label Specify port Agents check into Server with:.
  7. Save a copy, e.g. also in c:\temp\backup\notes.txt, of the current license of the Kaseya server. This license is located on the
    8. Configure page in the field to the right of the label License Code:.

    NOTE: If your current license is not for the Kaseya 2004 Enterprise Edition, then please contact your Kaseya sales representative. Do not proceed any further until you have obtained a valid license for the Enterprise Edition.
  8. Make a note of the Kaseya installation directory on your local disk drive, which by default is
    9. c:\Kaseya\.
  9. Click the
    10. Backup Now button on the Configure page. An SQL database backup will run within the next two minutes.
  10. To confirm the completion of the database backup, locate the SQL database backup file named
    11. \UserProfiles\@dbBackup\ksubscribers_db_yyyymmddhhmm.BAK. By default, the is c:\Kaseya\. The yyyymmddhhmm portion of the filename contains the current year, month, day, hour, and minute of the database backup. Copy this file to a backup folder, such as c:\temp\backup\.
  11. Copy the entire directory
    12. \UserProfiles\ to a backup folder, such as c:\temp\backup\. This directory contains the files associated with your managed machines.
  12. With the exception of the subdirectory VSAHiddenFiles, copy the entire directory
    13. \WebPages\ManagedFiles\ to a backup folder, such as c:\temp\backup\. This directory contains the scripts and managed files belonging to each administrator.

    WARNING: Do not copy VSAHiddenFiles from an old system to a new system. This directory contains many system helper files. Your new system installation contains the latest versions of these files.
  13. Copy the entire directory
    14. \WebPages\themes\banner\images\new to a backup folder, such as c:\temp\backup\themes\banner\images\new. This directory contains the customized icons, if any, for reports and the Agent when using the banner theme.
    Repeat for the compact theme and the default theme.
  14. From your
    15. Control Panel, open Add or Remove Programs.
  15. Select
    16. Kaseya Virtual System Administrator and click the Change/Remove button.
  16. Click
    17. No when you are prompted with the question: Do you want to save the Kaseya user data?
  17. Install your Microsoft SQL Server 2000 database server if you have not done so already.
  18. Set your SQL Server 2000 database server for mixed mode (SQL and Windows) authentication. Use the SQL Enterprise manager to open the
    19. Properties on the computer name in the SQL Server group. The authentication mode can be found on the Security tab.
  19. Run the Kaseya 2004 Enterprise Edition installation.
  20. On the
    21. Kaseya Server Network Settings page, enter the hostname or IP Address saved from the original installation. Enter an unused port number, such as 9876.

    WARNING: Do not enter the port number, which was saved earlier, at this time. By using a different port number, the Kaseya server will not accept connections from any existing Agents. You will enter the correct port number AFTER copying back the saved directories and restoring the database.
  21. When prompted, enter the original installation directory on your local drive and complete the installation.
  22. Copy back the
    23. UserProfiles and ManagedFiles directories saved from the original installation. Note that the ManagedFiles\VSAHiddenFiles directory created during the reinstallation will not be overwritten.
  23. Copy back the
    24. WebPages\themes\banner\images\new, WebPages\themes\compact\images\new, and WebPages\themes\default\images\new directories saved from the original installation to restore any customized icon images.
  24. Log in to your new VSA server as a master administrator.
  25. Select the
    26. System tab.
  26. Click on the
    27. Configure function.
  27. Click the
    28. Restore button on the Configure page.
  28. Select the SQL database backup by locating the backup file created earlier. Click the
    29. Restore button to confirm the database restore operation.
  29. After the database restore completes, log back in to the Kaseya server using one of the original administrator accounts.
  30. Confirm that the port number matches the port number saved earlier. If necessary, update with the original port number on the
    31. System tab, Configure function, by editing the port number and clicking on the Change Port button.

The Kaseya Agents on your managed machines that are online should begin to check in at this point, though some may remain offline for as long as an hour. The Agents will defer checkins for at most one hour due to the lack of response from any Kaseya Server.


Legacy Forum Name: Article 10023: Upgrade Kaseya MSDE to SQL Server,
Legacy Posted By Username: jimalves