This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Lansweeper Community
- Forums
- Archive
- Re: lansweeper database move
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Register to ask a question, start a topic or share an idea
Join the Community
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2011 12:35 PM
Hello
I have the lansweeper database on the SQL server. I have to move it to the new SQL box. What kind of re-configuration do I have to carry out? I know when you turn on the Lansweeper configuration utility it ask for a database - is it the only place where this setting has to be changed?
Maybe there ia a document which explains this process.
Thanks.
Marcin.
I have the lansweeper database on the SQL server. I have to move it to the new SQL box. What kind of re-configuration do I have to carry out? I know when you turn on the Lansweeper configuration utility it ask for a database - is it the only place where this setting has to be changed?
Maybe there ia a document which explains this process.
Thanks.
Marcin.
Labels:
- Labels:
-
Archive
6 REPLIES 6
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2011 02:01 PM
thanks 🙂
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2011 01:49 PM
Thanks.
My DBA is wondering if we could just deattached the dabase files from the current server and attached them to the new server, and after that recreate the users?
Where are lansweeperservice.exe.conf and web.config located?
My DBA is wondering if we could just deattached the dabase files from the current server and attached them to the new server, and after that recreate the users?
Where are lansweeperservice.exe.conf and web.config located?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2011 01:57 PM
My DBA is wondering if we could just deattached the dabase files from the current server and attached them to the new server, and after that recreate the users?
Yes, no problem. (but take a backup for safety)
Where are lansweeperservice.exe.conf and web.config located?
%programfiles%\lansweeper\service\lansweeperservice.exe.config
%programfiles%\lansweeper\website\web.config
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2011 01:32 PM
# Stop the Lansweeper service.
# Take a full backup of the lansweeper database using the SQL server management studio.
# On the new database server do a database only install of Lansweeper using the installer.
# 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 lansweeperservice.exe.config and web.config to point to the new server.
# Start the Lansweeper service.
# Take a full backup of the lansweeper database using the SQL server management studio.
# On the new database server do a database only install of Lansweeper using the installer.
# 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 lansweeperservice.exe.config and web.config to point to the new server.
# Start the Lansweeper service.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2011 12:57 PM
Hello
I do not move the lansweeper but only its database. The lansweeper is installed on the "server1", the SQL is installed on the "server2" - I am going to decommission "server2" and install a new SQL instance on the "server3". What shall I do? Thanks.
I do not move the lansweeper but only its database. The lansweeper is installed on the "server1", the SQL is installed on the "server2" - I am going to decommission "server2" and install a new SQL instance on the "server3". What shall I do? Thanks.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2011 12:39 PM
See this page: http://www.lansweeper.com/kb/move-lansweeper-to-different-server.aspx
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now
Related Content
- New Lansweeper install - Deployment does not run or log an attempt to run in General Discussions
- How does Lansweeper Support work? in General Discussions
- Lansweeper Bulk Asset Deletion Tool in Product Discussions
- migrate different server database data lost in General Discussions
- Manage Assets - Assets on wharehouse stock onto lansweeper in General Discussions
