This issue occurs when the database is not accessible for queries, and when the database is in a read-only regime.
When SQL Audit technology is used, sessions are written to the database that is audited.
EE and Trace write the session to the MASTER database, so this database should not be affected by "read-only" issue.
To prevent this issue from appearing switch to another audit technology: Extended Events (EE) or Trace.
To achieve this do the following:
1. Click on the Configure icon in the main ribbon bar
2. Select a SQL Server instance
3. Click the Add button
4. Choose technology in newly opened window, switch to Extended Event or Trace
5. Click the OK button to confirm new setting
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center