Migrating LanSweeper when your database is already hosted on its own system

[apiknowbler]

Summary

Description

The Lansweeper application is currently running on a Windows 2016 server and needs to be upgraded to Windows 2022. The migration involves setting up a new Windows 2022 server and transferring the LanSweeper application, which has its database hosted on a separate SQL server. 

Cause 

The need for migration arises from the requirement to upgrade the operating system from Windows 2016 to Windows 2022. This is often necessary to leverage new features, security updates, and improved performance that come with newer operating systems. The existing setup involves a separate SQL server for the LanSweeper database, which must be preserved during the migration process.

Troubleshooting

• Backup Important Files 
  Back up any custom website subfolders such as documents, images, widgets, and the Encryption.txt file located at: 
  Program Files (x86)\Lansweeper\Key\Encryption.txt
  • The following KB article provides an overview of the appropriate paths where custom content is stored: Where are Lansweeper data, reports, and settings stored?
• Stop Services on the Current Server 
  Stop both the Lansweeper Server service and your web server service (IIS Express or IIS) via Windows Services.
• Backup the Lansweeper Database 
  Create a backup of the Lansweeper database on your SQL server to have a safe restore point if needed. We recommend using the procedure described in this knowledge base article: Back up your installation
• Run the Lansweeper Installer on the New Server
  • Download the latest Lansweeper installer here: Update your installation
  • Launch the installer on the new server and select Advanced install.
  • Choose only New Lansweeper Service and New Lansweeper Website.
  • Do not select New Lansweeper Database to avoid overwriting your existing database.
  • For the database, select SQL Server and enter the instance name of your SQL server.
  • Choose the appropriate authentication method: either Windows authentication or SQL authentication using the lansweeperuser account and its password.
• Complete the Installation 
  Follow the prompts to finish setup. The Lansweeper service and website will be configured to connect to your existing database.
• Restore the Encryption Key 
  Replace the new Encryption.txt file with the backup you saved earlier to restore access to encrypted credentials and sensitive data.
• Update Configuration 
  Run ConfigEditor.exe located at: Program Files (x86)\Lansweeper\Tools\ConfigEditor.exe 
  If prompted about database password issues, enter the correct password for the lansweeperuser SQL account and save the configuration.
• Restart Services 
  Restart the Lansweeper Server service and your web server service (if needed).
• Restore Website Subfolders 
  Copy your previously backed-up website subfolders back into their original locations on the new server.