Monitoring a Microsoft SQL Server

[Kaplan, Andrew H.]

Hi there --
 
I tried connecting to port 1433 of the SQL server, and the connection was
refused. It appears that efforts to connect via the default
port will not work in this case. I took the liberty of running the nestat -abn
command syntax on the console of the SQL server, and
searched for all references to the sqlservr.exe binary. The results are shown
below:
 
Active Connections

[sqlservr.exe]

TCP 0.0.0.0:58477 0.0.0.0:0 LISTENING

[sqlservr.exe]

TCP 0.0.0.0:62502 0.0.0.0:0 LISTENING

[sqlservr.exe]

TCP 0.0.0.0:65249 0.0.0.0:0 LISTENING

[sqlservr.exe]

TCP 127.0.0.1:58751 0.0.0.0:0 LISTENING

[sqlservr.exe]

TCP 127.0.0.1:62503 0.0.0.0:0 LISTENING

[sqlservr.exe]

TCP 127.0.0.1:63954 127.0.0.1:63955 ESTABLISHED

[sqlservr.exe]

TCP 192.168.40.114:62502 192.168.40.122:50342 ESTABLISHED

[sqlservr.exe]

TCP 192.168.40.114:62502 192.168.40.125:60257 ESTABLISHED

[sqlservr.exe]

TCP 192.168.125.1:139 0.0.0.0:0 LISTENING

[sqlservr.exe]

TCP [::]:58477 [::]:0 LISTENING

[sqlservr.exe]

TCP [::]:62502 [::]:0 LISTENING

[sqlservr.exe]

TCP [::]:65249 [::]:0 LISTENING

[sqlservr.exe]

TCP [::1]:58751 [::]:0 LISTENING

[sqlservr.exe]

TCP [::1]:62005 [::1]:62006 ESTABLISHED

[sqlservr.exe]

UDP 0.0.0.0:123 *:* 

 

If the default port, 1433, is not reachable would one the above ports be the
alternate means of connecting to the server?

 

 



________________________________

From: Claudio Kuenzler [mailto:ck at claudiokuenzler.com] 
Sent: Thursday, November 17, 2011 1:39 PM
To: Nagios Users List
Subject: Re: [Nagios-users] Monitoring a Microsoft SQL Server


Please let us know if you get it working - I might have to add such a check soon
as well.

To answer your question: 1433 is the standard port of MSSQL so that should be
ok. You can launch nmap or a simple telnet to double-check that.


On Thu, Nov 17, 2011 at 4:34 PM, Jim Avery <jim at jimavery.me.uk> wrote:


	On 17 November 2011 15:17, Kaplan, Andrew H. <AHKAPLAN at partners.org>
wrote:
	> Hi there --
	>
	> Thanks for your reply. I tried your suggestion on the two plugins, and
here are
	> the results.
	>
	> When the command syntax for check_mssql was the following:
	>
	> ./check_mssql -H <ip address> -U <domain>\\<username> -P <password>
	>
	> or
	>
	> ./check_mssql -H <ip address> -U '<domain>\\<username>' -P <password>
	>
	> The error message displayed on-screen was:
	>
	> UNKNOWN: Invalid characters in the username.
	
	
	
	The check_mssql plugin is way too fussy about what characters it will
	allow in host names and user names.  On my system I edited the plugin
	to remove the if/else sections entirely below the comments "//
	Validate the hostname" and "// Validate the username".
	
	hth,
	
	Jim
	

	
------------------------------------------------------------------------------
	All the data continuously generated in your IT infrastructure
	contains a definitive record of customers, application performance,
	security threats, fraudulent activity, and more. Splunk takes this
	data and makes sense of it. IT sense. And common sense.
	http://p.sf.net/sfu/splunk-novd2d
	_______________________________________________
	Nagios-users mailing list
	Nagios-users at lists.sourceforge.net
	https://lists.sourceforge.net/lists/listinfo/nagios-users
	::: Please include Nagios version, plugin version (-v) and OS when
reporting any issue.
	::: Messages without supporting info will risk being sent to /dev/null
	




The information in this e-mail is intended only for the person to whom it is
addressed. If you believe this e-mail was sent to you in error and the e-mail
contains patient information, please contact the Partners Compliance HelpLine at
http://www.partners.org/complianceline . If the e-mail was sent to you in error
but does not contain patient information, please contact the sender and properly
dispose of the e-mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20111117/7933e93f/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null