Home
  •  

Database accessible

Microsoft.SQLServer.2008.ReportingServices.UnitMonitor.DeploymentWatcher.DBConnection (UnitMonitor)

The monitor changes its state and raises an alert if the deployment watcher fails to connect to Reporting Services Database

Knowledge Base article:

Summary

The monitor raises alert if the deployment watcher fails to connect to Reporting Services Database

Causes

There are many causes why the monitoring workflow may fail to connect to the database.

Some of which being

Overrideable Parameters

Name

Description

Default Value

Enabled

 

1

Generates Alerts

 

Yes

Interval (seconds)

The recurring interval of time in seconds in which to run the workflow.

900

Synchronization Time

 

 

Time out for database connection

The workflow will fail and register an event if it cannot access the database during specified time interval.

300

Element properties:

TargetMicrosoft.SQLServer.2008.ReportingServices.DeploymentWatcher
Parent MonitorSystem.Health.AvailabilityState
CategoryPerformanceHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SQLServer.2008.ReportingServices.MonitorType.Instance.DBConnectionMonitor
RemotableTrue
AccessibilityPublic
Alert Message
SSRS 2008: Deployment watcher cannot connect to Reporting Services Database
Deployment watcher cannot connect to Reporting Services Database. Received error message:
{0}
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.2008.ReportingServices.UnitMonitor.DeploymentWatcher.DBConnection" Accessibility="Public" Enabled="true" Target="SQLRS!Microsoft.SQLServer.2008.ReportingServices.DeploymentWatcher" ParentMonitorID="SystemHealth!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServer.2008.ReportingServices.MonitorType.Instance.DBConnectionMonitor" ConfirmDelivery="false">

  <Category>PerformanceHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServer.2008.ReportingServices.UnitMonitor.DeploymentWatcher.DBConnection.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/Property[@Name='Errors']$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Error" MonitorTypeStateID="Error" HealthState="Error"/>

    <OperationalState ID="Success" MonitorTypeStateID="Success" HealthState="Success"/>

  </OperationalStates>

  <Configuration>

    <DatabaseServerName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2008.ReportingServices.DeploymentWatcher"]/ServerFQDN$</DatabaseServerName>

    <DatabaseInstanceName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2008.ReportingServices.DeploymentWatcher"]/DBInstanceName$</DatabaseInstanceName>

    <DatabaseName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2008.ReportingServices.DeploymentWatcher"]/DBName$</DatabaseName>

    <TimeOut>300</TimeOut>

    <IntervalSeconds>900</IntervalSeconds>

    <SyncTime/>

  </Configuration>

</UnitMonitor>