Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Server & Application Monitor (SAM) > AppInsight for SQL: Database status is not calculated correctly in all cases

AppInsight for SQL: Database status is not calculated correctly in all cases

Overview

This article provides brief information and steps to resolve the issue when the Database status is not correctly calculated in all cases.

After a successful poll, the application results in a status Down even when the database is in the Up state. Also, child components are reported as being Down.
 

Environment

All SAM versions

 

Cause

The issue is caused when the AutoClose flag on the SQL database is enabled. 

Resolution

Disable the AutoClose flag on the SQL database. 

 

 

 

Last modified
20:48, 30 Nov 2016

Tags

Classifications

Public