Can I uninstall LocalDB 2014 now that Lansweeper uses LocalDB 2022?

[apiknowbler]

Summary

Scenario

Starting with Lansweeper version 11.3.0.5, LocalDB installations use Microsoft SQL Server 2022 LocalDB instead of SQL Server 2014 LocalDB. If your server previously ran SQL Server 2014 LocalDB, you can safely remove it once you confirm your installation uses SQL Server 2022 LocalDB.

Follow the steps below to confirm your configuration, back up your database, and uninstall the legacy SQL version without impacting your Lansweeper installation.

Prerequisites

• Administrator rights on the Lansweeper server.
• SQL Server Management Studio (SSMS) is recommended to inspect database properties.
• Access to Windows Services and Programs and Features (Add/Remove Programs).

Step 1: Confirm Your Lansweeper Database Uses SQL Server 2022 LocalDB

• Navigate to Configuration > Database tables in the Lansweeper web console. The SQL instance and version used is displayed as the first item on the page.

 

• You can also confirm this in SQL Server Management Studio by connecting to:

(localdb)\.\LSInstance

Then check the SQL Server version in the Object Explorer – SQL 2022 LocalDB should display as version 16.x or higher.

 

For more details on logging into LocalDB using SQL Server Management Studio (SSMS) check out the following KB article: Connect to SQL LocalDB using SQL Server Management Studio

 

Step 2: Create a Full Backup of Your Lansweeper Database

• Before removing any previous SQL components, create a backup to safeguard your data.
• Stop the following services from Windows Services:
  • Lansweeper Server
  • Lansweeper LocalDB Service
  • IIS Express or World Wide Web Publishing Service (if using IIS)

Follow the detailed steps outlined in Lansweeper KB to back up your database:  
👉 Back Up Your Installation

Confirm that a .bak file has been successfully created in your designated backup directory.

 

Step 3: Safely Remove SQL Server 2014 LocalDB

• Open Control Panel > Programs and Features.
• Locate and uninstall entries labeled:
  • Microsoft SQL Server 2014 LocalDB
• Restart your server after removal.

 

Step 4: Verify Lansweeper Operation Post-Removal

• Start the following services again:
  • Lansweeper LocalDB Service
  • Lansweeper Server
  • IIS Express or World Wide Web Publishing Service
• Open the Lansweeper web console in your browser.
• Confirm that the dashboard loads and assets appear correctly.