AuditWizard - Administration - General - Manually Changing SQL Connection
From Layton Support
(Difference between revisions)
(New page) |
m (Updated link) |
||
| (2 intermediate revisions by one user not shown) | |||
| Line 2: | Line 2: | ||
__FORCETOC__ | __FORCETOC__ | ||
=Overview= | =Overview= | ||
| − | It is recommended that you use the '''[[ | + | It is recommended that you use the '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard|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. |
| − | *The password for a SQL user is encrypted, and you won't be able to enter it, so you will have to use | + | =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. | ||
| + | |||
| + | #Navigate to the following location:<br /><p><code>C:\Program Files\AuditWizard v8\</code> (32 Bit)</p><p><code>C:\Program Files (x86)\AuditWizard v8\</code> (64 Bit)</p> | ||
| + | #Open the file ''AuditWizardv8.exe.config'' in Notepad. | ||
| + | #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. | ||
| + | #Change the string in the ''value'' tag to ''True''. | ||
| + | #Save and close the configuration file. | ||
| + | #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 ''. | *The Windows account you are using to run AuditWizard will have to have the Database Role Membership ''db_owner ''. | ||
| − | =Procedure= | + | ===Procedure=== |
#Navigate to the following location:<br /><p><code>C:\Program Files\AuditWizard v8\</code> (32 Bit)</p><p><code>C:\Program Files (x86)\AuditWizard v8\</code> (64 Bit)</p> | #Navigate to the following location:<br /><p><code>C:\Program Files\AuditWizard v8\</code> (32 Bit)</p><p><code>C:\Program Files (x86)\AuditWizard v8\</code> (64 Bit)</p> | ||
#Open the file ''AuditWizardv8.exe.config'' in Notepad. | #Open the file ''AuditWizardv8.exe.config'' in Notepad. | ||
| Line 18: | Line 33: | ||
#Save and close the configuration file. | #Save and close the configuration file. | ||
#Launch AuditWizard. | #Launch AuditWizard. | ||
| + | <p align="right">[[File:btn_back_up.png|link=User Guide for AuditWizard]] [[User Guide for AuditWizard|<u>Back to Contents</u>]]</p> | ||
Latest revision as of 04:59, 16 August 2016
Contents |
[edit] 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.
[edit] Database Type
[edit] 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.
- 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 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.
- Change the string in the value tag to True.
- Save and close the configuration file.
- Launch AuditWizard.
[edit] Connect to SQL Server Database
[edit] 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 .
[edit] 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.
