To move the database between SQL Server instances, follow these instructions.

 

Moving the database

First we need to move the database between servers.
Here is an outline of the tasks needed:

  1. Take the exMon databases offline to make sure no instance of exMon is running on the old instance, before and after we move the database.
  2. Backup the exMon database.
  3. Restore the exMon database on the new server.
  4. Create a SQL Login user with db_owner privileges on the new exMon database.

 

Updating database connections on servers

For all servers running exMon.

  1. Locate ExpectusConfig.config under C:\Program Files\exMon\Bin and open it with Notepad
  2. Update Data Source and Initial Catalog with your new hostname/instance name and database name respectably.
  3. Find and remove in two places exMonEncryptionString=XXXXXXXX
  4. Where exMonEncryptionString was, add: Password=XXXXX where XXXXX is your new password.
  5. Save and close.

exMon should work now but the password is saved in plaintext. To encrypt the password you need to run the exMon upgrade tool and choose Upgrade.

You can now test the database connection by opening C:\Program Files\exMon\Bin\ExpectusAdmin.exe.

 

exMon Portal

For servers running the exMon Portal

  1. Locate client.config under C:\Program Files\exMon\exMon\Portal and open it with Notepad
  2. Update Data Source and Initial Catalog with your new hostname/instance name and database name respectably.
  3. Find and remove exMonEncryptionString=XXXXXXXX
  4. Where exMonEncryptionString was, add: Password=XXXXX where XXXXX is your new password.
  5. Save and close.
  6. Open Internet Information Server (IIS) and restart the website exMon is running under. By default it is called Default Website.

exMon should work now but the password is saved in plaintext. To encrypt the password you need to run the exMon upgrade tool and choose Upgrade.

You can now test if the exMon Portal works.

 

exMon Administrator installed on local machines

For all machines where exMon Administrator was installed using the download link on the portal.

  1. Make sure the portal is using the new password by following the steps above.
  2. Uninstall exMon Administrator using Control Panel > Uninstall a program.
  3. Download exMon Administrator from the portal by hovering over the users name in the top bar.
  4. Install exMon Administrator.