If you install the Lansweeper database under Microsoft SQL LocalDB or Microsoft SQL Server, the Lansweeper installer automatically creates a SQL user that is used by the Lansweeper scanning service and web console to connect to the database. The default SQL user is lansweeperuser.
From Lansweeper version 220.127.116.11 onward, a random password is generated for lansweeperuser. For security reasons, this password is not displayed anywhere, so you may want to update it to a custom password of your choice if you intend to connect external tools to the Lansweeper database.
Only Lansweeper databases installed under SQL LocalDB or SQL Server have a password. Databases hosted under the deprecated Microsoft SQL Compact database server can only be queried by services running locally on your Lansweeper server and do not have a user account or password.
- Stop the Lansweeper Server service in Windows Services.
- Stop your web server service in Windows Services. Keep in mind that this will log everyone out of the console. Your web server service is either IIS Express or World Wide Web Publishing Service (IIS). If you're unsure which web server your console is running under, browse to the Configuration > Website Settings section of the web console and check the WebServer field.
- Open SQL Server Management Studio. If SQL Server Management Studio isn't installed on your Lansweeper server, we recommend downloading it online.
If your database is hosted in SQL LocalDB, the SQL instance name you need to submit in Management Studio is (localdb)\.\LSInstance and you can log in with the Windows user that initially installed Lansweeper. If your database is hosted in SQL Server, you would have configured your SQL instance name and password when you installed SQL Server.
- Right-click the lansweeperuser database user under Security > Logins and select Properties.
- Submit your new password twice in the available fields and select OK.
Do not submit "mysecretpassword0*" or "Mysecretpassword0*" as your new database password. These were the default database passwords in old Lansweeper releases and are no longer accepted as valid by Lansweeper.
- Run the ConfigEditor tool found at
Program Files (x86)\Lansweeper\Tools\ConfigEditor.exe on the server(s) hosting your Lansweeper Server service and web console.
- Click through any warnings the tool may be giving you about your password being incorrect.
- Select the Password field and select Edit.
- Submit the same password you previously submitted in SQL Server Management Studio and select Save.
- If the ConfigEditor tool has multiple tabs due to your server hosting multiple Lansweeper components, select the other tab, click through any warnings and repeat the password changing process.
- Restart the Lansweeper and web server services in Windows Services.
- If you have multiple scanning servers, update the database password on those servers as well by stopping the Lansweeper service, using the ConfigEditor tool and restarting the service.