Professional Employer Organizations (PEO).Once you're logged into SQL Server Management Studio, you can run the script below to grant lansweeperuser dbcreator and VIEW SERVER STATE rights. If your database is hosted in SQL Server, you would have configured your SQL instance name and password when you installed SQL Server.
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. Log into the application with a user that has sysadmin rights, a user other than lansweeperuser, and connect to your database instance. Install SQL Server Management Studio if not already present on your machine. What do I do if the database rights check fails? These rights are only required for the initial sync, not the continuous sync with Cloud. Note that, if you like, you can remove the dbcreator and VIEW SERVER STATE rights from lansweeperuser once the initial push to Cloud has finished. In installations performed under SQL Server, these rights are not automatically granted and you must manually grant them. In Lansweeper installations performed under the default SQL LocalDB database server, the aforementioned rights are automatically granted. In order for Lansweeper to verify whether enough space is available for the database backup, the user must also have VIEW SERVER STATE rights within your database instance. In order for Lansweeper to create a backup of your database, the user used for your local database connection (lansweeperuser) must have dbcreator rights within your database instance. After this initial sync, the database backup is removed and any further changes to your database are continuously synced up to Cloud as well. This backup is what is initially synced with your Cloud site. When you first set up a link with Cloud, a backup is performed of your local Lansweeper database. In addition to your database needing to be hosted on a compatible database server on a Windows machine, your database permissions must be correct in order for the link with Cloud to work. One of the checks is whether the setup and permissions of your local Lansweeper database are correct. When you hit the Link with Cloud site button in your local web console, a popup is presented with a pass/fail indication for a number of prerequisite checks. When you start setting up a link with your Cloud site, some prerequisite checks are performed to ensure your installation is ready to link.
0 kommentar(er)
