Home
»
Discussion Forums
»
Kserver Discussions - VSA
»
Article 10023: Upgrade Kaseya MSDE to SQL Server
Subscribe via RSS
Share this
Similar Posts
How to migrate Kaseya from MSDE 2000 to SQL Server 2005
by
LegacyPoster
on
Mar 28, 2008
Article 10011: After I install a SQL service pack for Microsoft SQL server, I can't access Kaseya.
by
LegacyPoster
on
Dec 16, 2004
MSDE not backing up, close to 2GB, unable to upgrade to SQL until it does backup
by
LegacyPoster
on
Jul 7, 2006
Article 10012: How do I apply Service Pack 3 to the Microsoft Desktop Engine (MSDE)?
by
LegacyPoster
on
Dec 9, 2004
Article 10003: I can't install the Kaseya Agent on my Kaseya Server.
by
LegacyPoster
on
Jun 22, 2007
View More
Details
0
Replies
0
Subscribers
Posted
over 16 years ago
Kserver Discussions - VSA
Article 10023: Upgrade Kaseya MSDE to SQL Server
Posted by
LegacyPoster
on
Dec 16, 2004 11:54 PM
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:
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.
Log in to your current VSA server as a master administrator.
Select the
System
tab.
Click on the
Configure
function.
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
Configure
page in the field to the right of the label
Change external name / IP address of Server:
.
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
Configure
page in the field to the right of the label
Specify port Agents check into Server with:
.
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
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.
Make a note of the Kaseya installation directory on your local disk drive, which by default is
c:\Kaseya\
.
Click the
Backup Now
button on the
Configure
page. An SQL database backup will run within the next two minutes.
To confirm the completion of the database backup, locate the SQL database backup file named
\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\
.
Copy the entire directory
\UserProfiles\
to a backup folder, such as
c:\temp\backup\
. This directory contains the files associated with your managed machines.
With the exception of the subdirectory VSAHiddenFiles, copy the entire directory
\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.
Copy the entire directory
\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.
From your
Control Panel
, open
Add or Remove Programs
.
Select
Kaseya Virtual System Administrator
and click the
Change/Remove
button.
Click
No
when you are prompted with the question:
Do you want to save the Kaseya user data?
Install your Microsoft SQL Server 2000 database server if you have not done so already.
Set your SQL Server 2000 database server for mixed mode (SQL and Windows) authentication. Use the SQL Enterprise manager to open the
Properties
on the computer name in the
SQL Server group
. The authentication mode can be found on the
Security
tab.
Run the Kaseya 2004 Enterprise Edition installation.
On the
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.
When prompted, enter the original installation directory on your local drive and complete the installation.
Copy back the
UserProfiles
and
ManagedFiles
directories saved from the original installation. Note that the
ManagedFiles\VSAHiddenFiles
directory created during the reinstallation will not be overwritten.
Copy back the
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.
Log in to your new VSA server as a master administrator.
Select the
System
tab.
Click on the
Configure
function.
Click the
Restore
button on the
Configure
page.
Select the SQL database backup by locating the backup file created earlier. Click the
Restore
button to confirm the database restore operation.
After the database restore completes, log back in to the Kaseya server using one of the original administrator accounts.
Confirm that the port number matches the port number saved earlier. If necessary, update with the original port number on the
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
You have posted to a forum that requires a moderator to approve posts before they are publicly available.