Nagios Support Forum

Hi,

I am stumped using check_mssql_server. Everything I do I get

CRITICAL:Unable to access SQL Server.

I've tried various flavours of

/usr/local/nagios/libexec/check_mssql_database.py -H "10.4.2.20" -U "sa" -P "password" -T "databasename" -p 1433 -I "LIVE" --datasize

on the console/commandline.

Ive tried ' around fields, Ive tried dynamic ports, variations on the instance. Some with instance, sometimes without. But nothing.


Can someone point me in the right direction?

If the DB is using instances you would need to remove the port

I got via putty session

/usr/local/nagios/libexec/check_mssql_database.py -H "10.4.2.20" -U 'sa' -P 'password' -T 'SQLdmNewsRepository' -I LIVE --activetrans --warning 10 --critical 20
CRITICAL:Unable to access SQL Server.


(Service Check Timed Out) via the GUI... created from the MSSQL config wizard.

Are you sure that the following are valid beyond a doubt?:

Username is actually Password is actually The table name is And that lastly you need to have a valid instance name, and it's name is The checks are case sensitive so be sure of that as well.

Yes, the username, password and database are correct as they are all written down on our Keepass Server Passwords List when we create the servers.

The instance is "live", I got the instance name using the SQL query on the server

select @@ServerName

Resulted in SQL3\Live (server\instance)


I've also tried
MSSQL$LIVE
MSSQLSERVER$LIVE
SQL3\LIVE
LIVE


* This is a clustered SQL server by the way.

If "Live" is the actual instance name, I believe it is case sensitive, have you tried it with the correct case set for each character?

Just checked.
Still no luck with this.

Ive also tried creating a new user, assigned db reader role to the database. still says
CRITICAL:Unable to access SQL Server.

I think its a permissions issue, is there anyway I can easily check?

Check the remote database systems logs. Do you see any "connection refused", "timeout" or access denied type errors?

If you are sure that the username and the password are correct, you need to check the firewall settings next. Make sure port 1433 (unless you use a different one) is open. Can you telnet to port 1433 from your nagios server?

Used putty, set IP and port to 1433

Screen went black, no text appeared