Moving Lansweeper database to new server

[dennisa95]

I want to move just the database for Lansweeper to another server. How do I reconfigure Lansweeper to connect to the database at the new location?

[Hemoco]

We recommend upgrading to 5.0 first. Please do the following:
- Take a full backup of your lansweeperdb database using SQL Server Management Studio.
- Upgrade your installation by following the instructions on page 164 and beyond of our online documentation.
- Stop the Lansweeper service.
- Take a full backup of your lansweeperdb database using SQL Server Management Studio.
- 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 and web 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.

[dennisa95]

We're on 4.2 currently

[Hemoco]

Which Lansweeper version are you using? 4.2 or 5.0?