Lansweeper is working fine. I can log into the web interface, scan items, etc. No problem. I have to migrate it to another server. I have followed the instructions, but I am unable to connect to the database.
I stopped the services, as described.
I installed the Microsoft SQL Management Studio
I enter the database name (localdb)\.\LSInstance
I set the Authentication to SQL Server Authentication
Here is where I'm stuck. The instructions state to log in with the ID used to install Lansweeper (admin in this case). BAD PASSWORD. During an update some time ago, the default web admin login was disabled and I had to use a different one to get into the web interface. I used that account. BAD PASSWORD. I did a lot of digging and found there is a user ID named lansweeperuser and tried that, but don't know the password as that is random generated on initial install.
I tried to change that password using the ConfigEditor, and matched the service and website passwords, but it will not save as it gets a "Login failed for user 'lansweeperuser'. (18456)", so I cannot change it. The DatabaseMaintenance tool has a "Backup" button, which does create a .bak file, but nothing documented how you restore this file.
Aside from the issues I'm having, this process is way overly complicated. If you have full admin rights on the web interface, there should be a database backup and restore option available there. The installer advanced option should have an import DB as well (with admin web account credentials required) as well as a database backup option (not just a link on how to back up the database).
I've searched the forum and the only apparent answer people get is that they are using the wrong password. Not very helpful. There is nothing in any of the backup/migration instructions for any kind of troubleshooting.
What do I need to do to migrate this system?