How can we help you today? How can we help you today?

Alert is not raised when Report Service Is stopped

Using Redgate monitor 9.0.3.20042 on a Windows server 2016 (OS Build 14393.3274 (1607) ) with Microsoft-IIS/10.0 and .NET 4.7.3062, Monitor database is  MSSQL 2017 14.0.3223.3.
I am monitoring an SQL SERVER 2017 14.0.3162.1 with both Power Bi Report server (BPIRS) and SQL Report Server (SSRS) installed.
When Their Service Stops, there is no alert raised.
They are both running on a VM which also using the same AD Account with full access in those both server and SQL.
On a side note: in order to install SQL monitor on IIS 10 had to remove compiler version.
these lines ...
<providerOption name="CompilerVersion" value="v3.5" />
SDPmrem71
0

Comments

7 comments

Sort by
  • PaulD
    I wouldn't expect SQL Monitor to raise an alert. These are two "other" windows services. They aren't SQL Server....
    PaulD
    0
  • SDPmrem71
    They have an Alert named "SQL SERVER Reporting Service status".
    I Think it should and it is a bug.
    SDPmrem71
    0
  • PaulD
    apologies, you're correct. I hadn't seen that.
    PaulD
    0
  • Russell D
    I'd expect an alert for SSRS, not PowerBI obviously. I'll see if I can reproduce it.
    Russell D
    0
  • Russell D
    Yes it certainly does look like this is broken, I've raised SRP-12580 to track this issue and will update here when I know more.
    Russell D
    0
  • Russell D
    It turns out that this happened because Microsoft changed SSRS 2017 to no longer be associated with a SQL Instance, whereas prior it had to be during the installation.

    There is a new alert under Machine level alerts for 2017+, and the old alert will be left as is for previous versions.
    Russell D
    0
  • SDPmrem71
    Thanks
    SDPmrem71
    0

Add comment

Please sign in to leave a comment.