Lansweeper Enterprise requirements

Lansweeper Enterprise is a Lansweeper feature that is currently in development. You can find more information on it and an early access signup form in the Enterprise menu of Lansweeper 7.1 installations. Keep in mind that the instructions in this knowledge base article will not provide access to Enterprise, but will simply ensure that Enterprise requirements are met once you are granted access.

To be able to push data from a local Lansweeper installation into Lansweeper Enterprise, your Lansweeper database must be hosted in Microsoft SQL Server. If your database is currently hosted in Microsoft SQL Compact, you can convert it to SQL Server by following the instructions in this knowledge base article.

In addition to the database being hosted in SQL Server, lansweeperuser must also have the dbcreator role in your SQL Server instance. Lansweeperuser is a SQL login created by the Lansweeper installer during an installation under SQL Server and connects Lansweeper components to the database. This user requires dbcreator rights for Lansweeper Enterprise because a backup copy of your database will be created, which will be used to push your data into Enterprise. By default, lansweeperuser does not have dbcreator rights and only has rights to the Lansweeper database. This results in the below warning message in the Configuration\Enterprise Options menu of the web console.

Lansweeper Enterprise necessary privileges

To give lansweeperuser the necessary dbcreator rights for Lansweeper Enterprise, do the following:

  1. Stop the Lansweeper Server service in Windows Services on your Lansweeper server.
    stopping the Lansweeper Server service
  2. 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).
    stopping the web server service
  3. Log into SQL Server Management Studio with a user that has sysadmin rights, a user other than lansweeperuser. If SQL Server Management Studio isn't installed on your Lansweeper server, we recommend downloading it online. (You will need to perform a search for the Management Studio that's compatible with your particular edition and version of SQL Server.)
  4. Under Security\Logins in SQL Server Management Studio, right-click lansweeperuser and select Properties
    lansweeperuser in SQL Server Management Studio
  5. In the Server Roles tab of the resulting popup, tick the dbcreator role and hit OK.
    giving dbcreator rights in SQL Server Management Studio
  6. Restart the Lansweeper and web server services.
    starting the Lansweeper Server service

Related Articles