Nagios Support Forum

Hi,

We are monitoring MSSQL Instance availability by installing NSclient++ in the windows servers and using MSSQLSERVER service from the windows server pulgin.But we getting unknown service for few servers from the portal but SQL service is working for server.We are getting error"Failed to open service MSSQLSERVER: 1060: The specified service does not exist as an installed service"

We are using the command as"check_xi_service_nsclient!Password7!SERVICESTATE!-l MSSQLSERVER -d SHOWALL".We even tried "check_xi_service_nsclient!Password7!SERVICESTATE!-l MSSQL$instance name -d SHOWALL" ,"check_xi_service_nsclient!Password7!SERVICESTATE!-l MSSQL/$instance name -d SHOWALL" and "check_xi_service_nsclient!Password7!SERVICESTATE!-l MSSQL$$instane name -d SHOWALL".


But the error still exist.Can any one help us.


Thanks & Regards
Gomathyshankar Selvakumar

What are you referencing here? Is this how your command looks? Same goes to this part, it doesn't look consistent - If it does contain a $, you may need to setup a user macro to handle this part. See this link for more information -
https://assets.nagios.com/downloads/nag ... Macros.pdf

For most of the servers,the instance name is the default server name so most actual command below below works perfectly for it: But few servers,the instance name is different the above mentioned does not work.So I googled and found the below mentioned command where instead MSSQLSERVER we have to use MSSQL\$(name of the instance).For some servers I am getting output using the below mentioned command.There are few servers for which I am still getting unknown error""Failed to open service MSSQLSERVER: 1060: The specified service does not exist as an installed service". Could u please help me with this error.

You'll want to setup a macro to use in place of MSSQL\$(name of instance) rather than referencing it directly.

See this link for information about how to set one up.
https://assets.nagios.com/downloads/nag ... Macros.pdf

issue sorted

I tried below mentioned command.It is working fine

Awesome! Going to close this one out on that note.