Sophos

Online support

Product maintenance

Contact support

Support services

Sophos NAC Advanced: Upgrading MSDE to SQL Express 2005 for NAC Advanced 3.04 requires you to uninstall the NAC databases, upgrade to SQL Express, and then upgrade NAC Advanced

Upgrading MSDE to SQL Express 2005 for NAC Advanced 3.04 requires you to uninstall the NAC databases, upgrade to SQL Express, and then upgrade NAC Advanced.

What to do

NAC 3.04 adds support for SQL Express 2005. To upgrade from MSDE to SQL Express 2005, you must peform the following steps so the NAC databases archive and purge data appropriately.

  1. Put the NAC application server in maintenance mode.
  2. Uninstall the Sophos NAC Advanced Databases. Uninstalling the NAC databases removes only the files that were used to create the databases and not the actual NAC databases themselves.
  3. Upgrade MSDE to SQL Express 2005.
  4. Install the NAC Advanced upgrade.

If you need more information or guidance, then please contact technical support.