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, this technique can be used to manually reconfigure the SQL connection. There are some caveats:

• The password for a SQL user is encrypted, and you won't be able to enter it, so you will have to use a Windows account.
• 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.