Martin_Thomas_1
Oct 09, 2013Nimbostratus
Microsoft SQL Reporting Services Monitoring
Hi,
I'm trying to create a monitor more complex than a basic "GET /" without checking the response and, essentially, just monitors if the port is open.
However, I'm failing miserably as SSRS 2008 no longer use IIS and I don't see how to implement this. Here's the two test I'm doing with curl and with a telnet. Unfortunately, it's not consistent. With a basic telnet, I'm getting a "Bad Request" response. I'm confused how to implement the monitor itself.
Note that the SSRS server I'm trying to monitor is not running a full-fledged SQL, just the Reporting Services.
[root@lb-que1-rc-03:Active] curl -v http://vmque1repsql01t/ReportServer -u gcg\\x-deltek:[masked] --anyauth* About to connect() to vmque1repsql01t port 80 (0)* Trying 10.252.8.77... connected* Connected to vmque1repsql01t (10.252.8.77) port 80 (0)> GET /ReportServer HTTP/1.1> User-Agent: curl/7.19.7 (i686-redhat-linux-gnu) libcurl/7.19.7 OpenSSL/0.9.8y zlib/1.2.3 libidn/0.6.5> Host: vmque1repsql01t> Accept: */*> < HTTP/1.1 401 Unauthorized< Content-Length: 0< WWW-Authenticate: Negotiate< WWW-Authenticate: NTLM< Date: Wed, 09 Oct 2013 18:19:08 GMT< * Connection 0 to host vmque1repsql01t left intact* Issue another request to this URL: 'http://vmque1repsql01t/ReportServer'* Re-using existing connection! (0) with host vmque1repsql01t* Connected to vmque1repsql01t (10.252.8.77) port 80 (0)* Server auth using NTLM with user 'gcg\x-deltek'> GET /ReportServer HTTP/1.1> Authorization: NTLM TlRMTVNTUAABAAAABoIIAAAAAAAAAAAAAAAAAAAAAAA=> User-Agent: curl/7.19.7 (i686-redhat-linux-gnu) libcurl/7.19.7 OpenSSL/0.9.8y zlib/1.2.3 libidn/0.6.5> Host: vmque1repsql01t> Accept: */*> < HTTP/1.1 401 Unauthorized< Content-Length: 0< WWW-Authenticate: NTLM TlRMTVNTUAACAAAAAwADADgAAAAGgokCbUO7oUECWnAAAAAAAAAAAJ4AngA7AAAABgGxHQAAAA9HQ0cCAAYARwBDAEcAAQAeAFYATQBRAFUARQAxAFIARQBQAFMAUQBMADAAMQBUAAQAEgBnAGMAZwAuAGwAbwBjAGEAbAADADIAVgBNAFEAVQBFADEAUgBFAFAAUwBRAEwAMAAxAFQALgBnAGMAZwAuAGwAbwBjAGEAbAAFABIAZwBjAGcALgBsAG8AYwBhAGwABwAIAJGduAscxc4BAAAAAA==< Date: Wed, 09 Oct 2013 18:19:08 GMT< * Connection 0 to host vmque1repsql01t left intact* Issue another request to this URL: 'http://vmque1repsql01t/ReportServer'* Re-using existing connection! (0) with host vmque1repsql01t* Connected to vmque1repsql01t (10.252.8.77) port 80 (0)* Server auth using NTLM with user 'gcg\x-deltek'> GET /ReportServer HTTP/1.1> Authorization: NTLM TlRMTVNTUAADAAAAGAAYAEAAAAAYABgAWAAAAAMAAwBwAAAACAAIAHMAAAANAA0AewAAAAAAAAAAAAAABoKJAjNgxXw0uMejAAAAAAAAAAAAAAAAAAAAADhBSEbbPQkdI8IkZUnhlhDovqfYcBOPd2djZ3gtZGVsdGVrbGItcXVlMS1yYy0wMw==> User-Agent: curl/7.19.7 (i686-redhat-linux-gnu) libcurl/7.19.7 OpenSSL/0.9.8y zlib/1.2.3 libidn/0.6.5> Host: vmque1repsql01t> Accept: */*> < HTTP/1.1 200 OK< Cache-Control: private< Content-Length: 457< Content-Type: text/html; charset=utf-8< Server: Microsoft-HTTPAPI/2.0< X-AspNet-Version: 2.0.50727< Date: Wed, 09 Oct 2013 18:19:08 GMT< vmque1repsql01t/ReportServer - /
vmque1repsql01t/ReportServer - /
* * *
Tuesday, February 09, 2010 6:23 PM <dir> [Vision](?%2fVision&rs:Command=ListChildren)
* * *
Microsoft SQL Server Reporting Services Version 10.50.2769.0
* Connection 0 to host vmque1repsql01t left intact
* Closing connection 0
[root@lb-que1-rc-03:Active] cotelnet vmque1repsql01t 80
Trying 10.252.8.77...
Connected to vmque1repsql01t.
Escape character is '^]'.
GET /ReportServer HTTP/1.1Host: vmque1repsql01t\r\nConnection: close\r\n\r\n
HTTP/1.1 400 Bad Request
Content-Type: text/html; charset=us-ascii
Server: Microsoft-HTTPAPI/2.0
Date: Wed, 09 Oct 2013 18:19:23 GMT
Connection: close
Content-Length: 311
Bad Request
Bad Request
* * *
HTTP Error 400. The request is badly formed.
Connection closed by foreign host.