Moving database from Express SQL to a remote SQL server

[AddamC]

We originally installed Lansweeper using SQL Express edition within the same server. Now we are planning to move the Lansweeper database from Express to a remote SQL 2005 server.

I read through the knowledge base articale "how to move Lansweeper server" (http://www.lansweeper.com/kb/move-lansweeper-to-different-server.aspx). I would like to know if we only want to move the database to different server what are the proper steps to approach that.

Thanks,

[Hemoco · Accepted solution]

# 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. (make sure your database name is "lansweeperdb")
# With SQL server management studio recreate the user "Lansweeperuser" and give it the same password as in your web.config file (default: mysecretpassword0*)
# check web.config and lansweeperservice.exe.config if they have the correct username/database/password.
# Make the "lansweeperuser" owner of the database "lansweeperdb"
# Start the Lansweeper service.