Issue
- Vista - Log database offline
- Access denied
Environment
- Vista
- SQL
Cause
Receiving an alarm in Vista about "log database offline," means that the DSS writer has somehow failed to read to SQL Database. Every time this happens, an application event should be created in the Windows Event View. It can be caused by several different reasons, but the most common are:
- SQL is not reachable
- A virus scan is under progress for the created event under the $queue folder
Resolution
These steps may vary slightly depending on the operating system installed on the PC. These steps describe the process in Windows XP.
- Highlight "My Computer," right-click, and choose Manage
-
Choose Event Viewer and click on "Application"
- Check for Type "Error" and Source "Vista" at the same time range as the alarm in Vista
- Double click on the alarm and read the explanation for it
If a virus program is installed, make sure the $queue folder is in the exception list.