AuditWizard - Administration - General - Repairing a SQL Compact Database
From Layton Support
Overview
If you have not changed the database to a SQL server, you are using the built-in SQL Compact database. If you can't launch AuditWizard, the log may show this entry:
ERROR Layton.AuditWizard.DataAccess.DatabaseConnection Error in OpenCeConnection()
The database file may be corrupted. Run the repair utility to check the database file.
The "repair utility" is Microsoft SQL Server Management Studio 2005 or 2008. The database file name is aw_db.sdf. It is located here:
C:\Program Files (x86)\AuditWizard v8\db\
Note that versions of Microsoft SQL Server Management Studio later than 2008 R2 cannot open SQL Compact databases, as the functionality has been removed.
Repair Procedure
This procedure uses Microsoft SQL Server Management Studio 2005. This procedure is to be done on the AuditWizard server.
- If you don't have Microsoft SQL Server Management Studio 2005, download the free installer from here. Choose either the SQLManagementStudio_x64_ENU.exe or SQLManagementStudio_x32_ENU.exe version, depending on your system. This should be installed on the AuditWizard computer.
- Navigate to C:\Program Files (x86)\AuditWizard v8\db\.
- Copy the database, filename aw_db.sdf, elsewhere as a backup.
- Open SQL Server Management Studio.
- Select Connect Object Explorer from the File menu.
- Change the Server type to SQL Server Compact.
- Select <Browse for more...> from the Database file menu.
- Navigate to C:\Program Files (x86)\AuditWizard v8\db\.
- Select aw_db.sdf and open it.
- SQL Server Management Studio will tell you that the database is corrupted and will ask if you want to repair it. Confirm this and it will be repaired. It will take some time.
- Disconnect from the database.
- Launch AuditWizard. It will take some time until the application is ready to use.
It is highly recommended at this point that you migrate the SQL Compact database to SQL Server.
