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 6.0.100.0 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.
To change the random database password generated by the Lansweeper installer, do the following:
- 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 following section of the web console and check the WebServer field: Configuration\Website Settings
- 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 hit 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 following tool on the server(s) hosting your Lansweeper Server service and web console:Program Files (x86)\Lansweeper\Tools\ConfigEditor.exe
- Click through any warnings the tool may be giving you about your password being incorrect.
- Select the Password field and hit the Edit button.
- Submit the same password you previously submitted in SQL Server Management Studio and hit the Save button.
- 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.