AuditWizard - Administration - General - Manually Changing SQL Connection

Back to Contents

Overview

It is recommended that you use the Change Database Wizard to change the connection to a different SQL database, however, if you can't launch the application, these techniques can be used to manually reconfigure the SQL connection.

Database Type

Reconnect to SQL Compact Database

If for any reason you wanted to reconnect to the built-in SQL Compact database after migrating to SQL Server, the connection must be established manually. It is assumed that you would not want to return to using SQL Compact after migration, so this procedure would only be used in rare cases.

1. Navigate to the following location:
   

   C:\Program Files\AuditWizard v8\ (32 Bit)

   C:\Program Files (x86)\AuditWizard v8\ (64 Bit)

2. Open the file AuditWizardv8.exe.config in Notepad.
3. Find the string CompactDatabaseType. This tag is a boolean value for whether the SQL Compact or a SQL Server database is used. Simply changing it to True will ignore the SQL Server details below it.
4. Change the string in the value tag to True.
5. Save and close the configuration file.
6. Launch AuditWizard.

Connect to SQL Server Database

Note

There are some caveats with this procedure:

• The password for a SQL user is encrypted, and you won't be able to enter it, so you will have to use the Windows authentication method.
• The Windows account you are using to run AuditWizard will have to have the Database Role Membership db_owner .

Procedure

1. Navigate to the following location:
   

   C:\Program Files\AuditWizard v8\ (32 Bit)

   C:\Program Files (x86)\AuditWizard v8\ (64 Bit)

2. Open the file AuditWizardv8.exe.config in Notepad.
3. Find the string ConnectionStringExpressDataSource. This is the tag for the SQL Server name, including instance name, if applicable.
4. Correct the SQL Server name in the value tag, if necessary.
5. Find the string ConnectionStringExpressInitialCatalog. This is the SQL database name.
6. Correct the SQL database name in the value tag, if necessary.
7. Find the string ConnectionStringExpressIntegratedSecurity. This indicates which authentication method will be used, either Windows NT or SQL Server.
8. Ensure that the value tag is True. This means Windows NT.
9. Save and close the configuration file.
10. Launch AuditWizard.

Back to Contents