This page explains how to connect to your Lansweeper SQL LocalDB database using SQL Server Management Studio (SSMS).
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 (MSSQL) 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 (SSMS).
Connect to your Lansweeper SQL LocalDB database
To connect to your LocalDB instance, you can use SQL Server Management Studio (SSMS). 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.
- 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.
- Windows Authentication
The user account you are logged on as is automatically selected when you select Windows Authentication. Make sure to log on with the user account that last installed or updated Lansweeper as this is the SA account to your SQL LocalDB instance. Only the SA account can connect to the LocalDB instance.
You can verify which user performed the last installation or update by opening the Registry Editor on your Lansweeper server.
Navigate to:HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\Lansweeper_is1
Check the value for: Inno Setup CodeFile: InstalledBy.
If the user account that last installed or updated Lansweeper is no longer available, you can modify the Inno Setup CodeFile: InstalledBy value in the registry to another user account.
Make sure to restart the Lansweeper LocalDB service afterwards.
- SQL Server Authentication
By default, the SQL user lansweeperuser has access to your SQL LocalDB instance. This user is created during the installation of Lansweeper and is assigned a random password. The first time you connect to your LocalDB instance, you will need to log in as the Windows user that performed the Lansweeper installation. Once you're connected to your instance, you can configure a custom password for the lansweeperuser account.
- Windows Authentication
Was this post helpful? Select Yes or No below!
Did you have a similar issue and a different solution? Or did you not find the information you needed? Create a post in our Community Forum for your fellow IT Heroes!
More questions? Browse our Quick Tech Solutions.
