Background

After upgrading the Hach WIMS Database Management System from MSDE running against OPS SQL, DBA Helper may stop functioning.

Examining the DBA Helper logs will show an error similar to the following:

The column name could be different from mirror_count.
This is due to a failure in the upgrade process going from MSDE to SQL Server Express 2005. More information is in this Microsoft KB article:
http://support.microsoft.com/kb/914781/en-us

Work-around:

1. Detach all Hach WIMS Facilities (Databases that have the OPS prefix) and back them up to a different location
   
2. Uninstall the OPSSQL SQL Server Express instance from Control Panel -> Add/Remove programs
   
3. Install a fresh SQL Server 2005 Express SP3 instance, downloaded from here:
   http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx
   Make sure you name the instance OPSSQL and configure it for mixed-mode authentication. Set the SA password to opssqlexpress2005admin (without the quotes)
   
4. Re-attach the Hach WIMS Databases that were attached in step 1.