AuditWizard - Troubleshooting - .ERROR Files
From Layton Support
(Difference between revisions)
m (Updated with SQL Server 2012 dialog) |
m (Modified Back link) |
||
Line 1: | Line 1: | ||
− | <p align="right">[[File:btn_back_up.png|link= | + | <p align="right">[[File:btn_back_up.png|link=AuditWizard™ - Troubleshooting - Audit Files Not Uploading]] [[AuditWizard™ - Troubleshooting - Audit Files Not Uploading|<u>Back</u>]]</p> |
=Overview= | =Overview= | ||
When ''.ERROR'' is appended to the ADF file name, this typically means that the account under which the AuditWizard service is running does not have permissions to access the database. | When ''.ERROR'' is appended to the ADF file name, this typically means that the account under which the AuditWizard service is running does not have permissions to access the database. | ||
Line 13: | Line 13: | ||
#Click the ''Owned Schemas'' page and ensure that ''db_owner'' is checked.<br /><p>[[File:Aw db role memship02.png|link=]]</p><br /> | #Click the ''Owned Schemas'' page and ensure that ''db_owner'' is checked.<br /><p>[[File:Aw db role memship02.png|link=]]</p><br /> | ||
#Click the ''Membership'' page and ensure that ''db_owner'' is checked.<br /><p>[[File:Aw db role memship03.png|link=]]</p><br /> | #Click the ''Membership'' page and ensure that ''db_owner'' is checked.<br /><p>[[File:Aw db role memship03.png|link=]]</p><br /> | ||
− | <p align="right">[[File:btn_back_up.png|link= | + | <p align="right">[[File:btn_back_up.png|link=AuditWizard™ - Troubleshooting - Audit Files Not Uploading]] [[AuditWizard™ - Troubleshooting - Audit Files Not Uploading|<u>Back</u>]]</p> |
Revision as of 03:22, 9 October 2015
Overview
When .ERROR is appended to the ADF file name, this typically means that the account under which the AuditWizard service is running does not have permissions to access the database.
Fix
- In AuditWizard, go to Administration > General > AuditWizard Services.
- Click the Service Control button. The following dialog will be displayed:
- Note the account in the Username field being used to run the service.
- Alternatively, if you can't launch AuditWizard, open the Services console and get Properties on the AuditWizardService service. Click the Log On tab to view the account setting:
- Launch SQL Server Management Studio.
- Expand Server > Databases > AuditWizard > Security > Users.
- If the service account is not present, add it. If it is present, right-click it and select Properties.
- Click the Owned Schemas page and ensure that db_owner is checked.
- Click the Membership page and ensure that db_owner is checked.