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. Key differences between the database servers are listed as well, to help you decide which one to select. Note that SQL Compact was an old database server option, which is no longer supported. If you are still using SQL Compact as your Lansweeper database server, you should convert your database to SQL LocalDB or SQL Server.

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 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...)
    • Microsoft SQL Server 2019, 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 Compact4GBunsupported from March 2020 onward
SQL LocalDB10GBsupported database server
SQL Server
(manual install required prior to installing Lansweeper)
• 4GB (free Express editions lower than 2008 R2)
• 10GB (free Express edition 2008 R2 or higher)
• unlimited (other editions)
supported database server

Related Articles