Home
  •  

Reporting SQL Server Connection Failed

Microsoft.ApplicationVirtualization.5.Server.MP.ReportSQL (UnitMonitor)

Failed to connect to SQL server.

Knowledge Base article:

Summary

Failed to connect SQL server

Configuration

The monitor generates an alert when Event 100 is logged to Microsoft-AppV-Server Reporting/Admin and automatically resolves after five minutes

Causes

See the Event Description

Viewable in Alert Context or Event View

For Event View be sure to view Event 100 from the appropriate Reporting Server

Resolutions

Validate that the Reporting SQL Server is on and connected to Active Directory

Verify that the Reporting SQL Connection String is valid. This can be found in the Reporting Server registry at path HKLM\SOFTWARE\Microsoft\AppV\Server\ReportingService\REPORTING_SQL_CONNECTION_STRING

Validate that the Reporting Service install admin account has public access to schema-version table in Reporting Database.

External

Please refer to http://go.microsoft.com/fwlink/?LinkId=277083 for information on deploying and configuring the Reporting Server and http://go.microsoft.com/fwlink/?LinkId=277084 for deploying and configuring Reporting Database

Element properties:

TargetMicrosoft.ApplicationVirtualization.5.Server.MP.ReportingService
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.Windows.SingleEventLogTimer2StateMonitorType
RemotableTrue
AccessibilityPublic
Alert Message
Reporting SQL Server Connection Failed
The Reporting SQL Server may not be available
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.ApplicationVirtualization.5.Server.MP.ReportSQL" Accessibility="Public" Enabled="true" Target="Microsoft.ApplicationVirtualization.5.Server.MP.ReportingService" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.SingleEventLogTimer2StateMonitorType" ConfirmDelivery="true">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Microsoft.ApplicationVirtualization.5.Server.MP.ReportSQL_AlertMessageResourceID">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

  </AlertSettings>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

    <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

    <LogName>Microsoft-AppV-Server-Reporting/Admin</LogName>

    <Expression>

      <And>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="UnsignedInteger">100</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="String">PublisherName</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">Microsoft-AppV-Server-Reporting</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </And>

    </Expression>

    <TimerWaitInSeconds>300</TimerWaitInSeconds>

  </Configuration>

</UnitMonitor>