Compatible SQL database servers for hosting the Lansweeper database

Lansweeper data, reports and settings are stored in a database. Below you can find a list of supported database servers for hosting the Lansweeper database. Using SQL Server or SQL LocalDB is recommended if you have a network of more than 1,000 assets or if you plan on using the Lansweeper help desk, as these database servers offer more space and better performance. Other key differences between the database servers are listed below as well, to help you decide which one to select.

For other Lansweeper installation requirements like architecture, operating system, disk space, web browser and installed software, please review this knowledge base article.

List of supported database servers

The following database servers are supported for hosting the Lansweeper database:

  • Microsoft SQL Compact
  • Microsoft SQL LocalDB
  • Microsoft SQL Server
    • Microsoft SQL Server 2005, any edition (Express, Standard, Enterprise...)
    • Microsoft SQL Server 2008, any edition (Express, Standard, Enterprise...)
    • Microsoft SQL Server 2008 R2, any edition (Express, Standard, Enterprise...)
    • Microsoft SQL Server 2012, any edition (Express, Standard, Enterprise...)
    • Microsoft SQL Server 2014, any edition (Express, Standard, Enterprise...)
    • Microsoft SQL Server 2016, any edition (Express, Standard, Enterprise...)
    • Microsoft SQL Server 2017, any edition (Express, Standard, Enterprise...)

Database type comparison

The table below lists some key differences between the database servers. We recommend reviewing this table to determine which database server you need when installing Lansweeper. This prevents you from having to migrate your data to a different database server at a later time.

Database serverPackaged with LansweeperMax database sizeSupport for distributed Lansweeper componentsSupport for multiple scanning serversLansweeper support status
SQL Compact4 GBunsupported from March 2020 onward
SQL LocalDB10 GBsupported database server
SQL Server
(manual install required prior to installing Lansweeper)
• 4 GB (free Express editions lower than 2008 R2)
• 10 GB (free Express edition 2008 R2 or higher)
• unlimited (other editions)
supported database server

Related Articles