Moving the exMon database

Created by: Kristinn Magnusson

To move the exMon 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. Back up 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 Data Governance installed on local machines

For all machines where exMon Data Governance 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 Data Governance using Control Panel > Uninstall a program.

  3. Download exMon Data Governance from the portal by hovering over the user's name in the top bar.

  4. Install exMon Data Governance.

Note: If you require any assistance, please contact us here

Kristinn is the author of this solution article.