From Lansweeper 7.2 onward, SQL LocalDB is one of the available database server options for hosting your Lansweeper database. Lansweeper LocalDB is a custom variant of Microsoft SQL Server 2014 Express. It was introduced as a replacement for the now deprecated Microsoft SQL Compact database server.
To perform certain actions such as backing up and restoring your database, you will need to be able to manage your database directly. This knowledge base article explains how to connect to your Lansweeper SQL LocalDB database using SQL Server Management Studio.
Connect to your Lansweeper SQL LocalDB database
To connect to your LocalDB instance, you can use SQL Server Management Studio. A connection requires you to submit a server name and a user account to authenticate.
- Run SQL Server Management Studio on your Lansweeper server. Microsoft SQL LocalDb does not support remote connections. As such the database must be connected to from your Lansweeper server itself. Install and run SQL Server Management Studio (SSMS) on the same machine where you've installed Lansweeper. SSMS can be downloaded via the Microsoft website.
You can only connect to your SQL LocalDB instance locally on the machine hosting your Lansweeper installation.
- Submit the server name. For SQL LocalDB the server name should always be "(localdb)\.\LSInstance".
- Select your authentication type. You can use Windows Authentication or SQL Server Authentication.