(Note: This article affects AuthAnvil Two Factor Auth v4.6 and older. These instructions will not work for v5. Contact our support team for assistance with database migration in 2FA v5)
It's a fairly straightforward process, you just need to complete the following steps:
- Back up your AuthAnvil database using the aabackup tool as a safety precaution. See "Backing up the AuthAnvil database" in the AuthAnvil Installation Guide.
- Move the AuthAnvil database from the old SQL server to the new SQL server using the standard SQL server tools.
- Reset the password on the aadbuser account on the AuthAnvil server in Computer Management to a known value. We recommend using a complex password that is not well known.
- Add an aadbuser Windows account to the new SQL server computer, giving it the same password that you set in step 3.
- Add the aabduser user account that you created in step 4 as a login to the new SQL server, assigning it sysadmin privileges.
- Map that user to the Anvil database, assigning it the db_owner role for the database.
- Use the instructions in Appendix C of the AuthAnvil Installation Guide to open up the Web Config Editor and tab through the fields until the Apply button is highlighted, then hit ctrl-o.
- Change the connection string to point to the servername\instancename for the new SQL server, and change the aadbuser password to reflect the new password that you set in step 3 and run an IIS Reset
- Test the login to make sure that it works.
If you have any questions or need some help, we would be happy to assist. Open a case at kaseya.zendesk.com .