This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
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
- Database Scanner in General Discussions
- Interest Check: December Community Event – Scanning Deep Dive & Troubleshooting Tips in General Discussions
- Do we lose our on-premise setup if we move to Lansweeper Sites? in Technical Troubleshooting
- Collect Lansweeper Audit Logs (e.g. Login events) in Reports & Analytics
- Trouble with iis express. Keeps stopping every few minutes in Product Discussions
