How to move Lansweeper to a different server.
- Stop the Lansweeper service on your current setup.
- Take a full backup of your lansweeperdb database using SQL Server Management Studio.
- If you added any custom images to Lansweeper, you may want to copy these files as well.
Custom images can be found in Program Files/Lansweeper/Website/actions and Program Files/Lansweeper/Website/userpictures.
- Do a full installation of Lansweeper on your new setup. Our latest installer can be found here.
- Stop the Lansweeper service on the new server.
- Do a restore of the database backup and overwrite the lansweeperdb database on the new server.
- Execute the below script in SQL Server Management Studio.
This will ensure that the SQL user for your Lansweeper database is configured correctly.
use lansweeperdb
GO
drop schema lansweeperuser
GO
drop user lansweeperuser
go
execute sp_droplogin lansweeperuser
go
use master
GO
EXEC sp_addlogin 'lansweeperuser', 'mysecretpassword0*', 'lansweeperdb', [English]
GO
use lansweeperdb
go
EXEC sp_grantdbaccess 'lansweeperuser', 'lansweeperuser'
GO
EXEC sp_addrolemember [db_owner], 'lansweeperuser'
Go
- In your Lansweeper configuration files make sure that the Data Source, User ID and Password correspond with your SQL Server settings.
The config files are: Program Files\Lansweeper\Service\Lansweeperservice.exe.config and Program Files\Lansweeper\Website\web.config
- Execute the below script in your Lansweeper configuration console under Lansweeper/Database Scripts.
Replace “newserver” with the name of your new scanning server.
update tsysasservers set servername='newserver'
- Copy any custom images from your old setup to your new one and restart the Lansweeper service on your new server.
Most requested articles:
|
