The SQL Server Reporting Services: MSSQLSERVER

Microsoft.Dynamics.CRM.2011.The_SQL_Server_Reporting_Services__MSSQLSERVER_Health (UnitMonitor)

The SQL Server Reporting Services: MSSQLSERVER Is Not Running

Knowledge Base article:

Summary

SSRS is not running.

Causes

View the event logs for further information. A service can stop for many reasons, including:

The service was stopped by an administrator

The service was prevented from starting because the user account could not be authenticated.

The service encountered an exception that stopped the service.

The service was improperly configured, which prevented it from starting.

Resolutions

Try to restart the service manually and review events for additional details.

You can attempt to restart the service by doing the following:

1. Open a remote desktop connection to the server that generated the alert.

2. Run services.msc

3. Right click on the "SQL Server (MSSQLSERVER) " and click "Start".

Element properties:

TargetMicrosoft.Dynamics.CRM.2011.SSRS_Servers
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveTrue
Monitor TypeMicrosoft.Windows.CheckNTServiceStateMonitorType
RemotableTrue
AccessibilityPublic
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.Dynamics.CRM.2011.The_SQL_Server_Reporting_Services__MSSQLSERVER_Health" Accessibility="Public" Enabled="true" Target="Microsoft.Dynamics.CRM.2011.SSRS_Servers" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.CheckNTServiceStateMonitorType" ConfirmDelivery="false">
<Category>AvailabilityHealth</Category>
<OperationalStates>
<OperationalState ID="Running" MonitorTypeStateID="Running" HealthState="Success"/>
<OperationalState ID="NotRunning" MonitorTypeStateID="NotRunning" HealthState="Warning"/>
</OperationalStates>
<Configuration>
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<ServiceName>ReportServer</ServiceName>
<CheckStartupType/>
</Configuration>
</UnitMonitor>