AuditWizard - Administration - General - Manually Changing SQL Connection
From Layton Support
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
- Navigate to the following location:
C:\Program Files\AuditWizard v8\
(32 Bit)C:\Program Files (x86)\AuditWizard v8\
(64 Bit) - Open the file AuditWizardv8.exe.config in Notepad.
- Find the string ConnectionStringExpressDataSource. This is the tag for the SQL Server name, including instance name, if applicable.
- Correct the SQL Server name in the value tag, if necessary.
- Find the string ConnectionStringExpressInitialCatalog. This is the SQL database name.
- Correct the SQL database name in the value tag, if necessary.
- Find the string ConnectionStringExpressIntegratedSecurity. This indicates which authentication method will be used, either Windows NT or SQL Server.
- Ensure that the value tag is True. This means Windows NT.
- Save and close the configuration file.
- Launch AuditWizard.