Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Helena
Engaged Sweeper
We need to move our database from a SQL Server 2000 box to a new server running SQL Server 2005. Are there any additional steps to those listed in the various articles explaining how to move the database?
1 REPLY 1
Hemoco
Lansweeper Alumni
# Stop the Lansweeper service.
# Take a full backup of the lansweeper database using the SQL server management studio.
# Do a restore of the database backup and overwrite the Lansweeperdb database on the new server.
# With SQL server management studio recreate the user "Lansweeperuser" and give it the same password as in your web.config file (default: mysecretpassword0*)
# Make the "lansweeperuser" owner of the database "lansweeperdb"
# Edit web.config and lansweeperservice.exe.config to reflect the changes.
# Restart the Lansweeper service on the new server.

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now