Summary
Description
The issue involves database permission errors with Lansweeper's new auto-update feature. This feature requires specific permissions for the Lansweeperuser account on the SQL instance. Error messages indicate insufficient permissions during auto-update attempts.
Information
The database permission errors relate to Lansweeper's auto-update. The Lansweeperuser account on the SQL instance needs two permissions:
- dbcreator role: Allows Lansweeper to create a database backup, providing a restore point if the auto-update needs to roll back.
- view server state permission: Allows Lansweeper to monitor database and backup storage usage.
Solution
The following KB article includes an SQL statement granting the required role and permission to the lansweeperuser account: Enable the Lansweeper scan server to auto-update - Lansweeper Community - 79957
You can also assign permissions manually in SQL Server Management Studio (SSMS):
- Open SSMS and connect to the SQL instance hosting the Lansweeper database.
- Go to Security > Logins and find lansweeperuser.
- Right-click the account and select Properties.
- Under Server Roles, check dbcreator.
- Under Securables, locate 'View server state' and tick 'Grant'.
- Afterward, it is recommended to restart the following services:
- IIS Express (or World Wide Web Publishing Service)
- Lansweeper Server service.
After these changes, permission errors should no longer appear in the Lansweeper web console.
