Instructions for Moving Lansweeper database to new server?

[bdoser]

we're going to be moving our lansweeper database to a new server and I was wondering if there were instructions available on how to do so?

is it a straight up copy the database kinda thing?

Old server is running Lansweeper 4.1.0.132. New server is running the latest production version of Lansweeper (not beta)

[Hemoco]

Unfortunately, we cannot provide support for additional changes made to your Lansweeper installation. There is always a risk that these will break during upgrades.
All data obtained through standard Lansweeper functionality is preserved during upgrades, including info manually entered into custom fields.

[bdoser]

Awesome! thank you for the help. one question. if we've made some minor customization to the database to display some of the web content differently (specificically columns in the device overview section) will we wipe out those custom changes? in addition will all device overview information that's been entered manually still be correct after the upgrade?

[Hemoco]

We recommend you first upgrade your current server to 4.2. Instructions on upgrading can be found on page 103 of our online documentation.
Please refer to page 102 of our online documentation for general instructions on moving your Lansweeper installation.


If you are just looking to move the database, the steps are the following:

- Stop your Lansweeper service.
- Take a full backup of your lansweeperdb database using SQL Server Management Studio. Instructions on backing up and restoring your database can be found on page 99 of our online documentation.
- Run the Lansweeper installer on your new database server. Choose New Installation\Advanced Install and select only the database for installation.
- 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 the Lansweeper configuration files on your scanning server 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
%Program Files%\Lansweeper\Website\web.config

- Restart your Lansweeper service.