Random Project

Connecting to the SQL Server

There is an english translation on the project site.

Connecting with the perl Sybase module can be somewhat tricky.
I finally got a succesfull connection this way:

1 – Edit /etc/freetds/freetds.conf

[sqlhost1]
host = 192.168.1.1
port = 1433
tds version = 8.0

2 – Use the –server command line option instead of the –hostname option:

check_mssql_health –server=sqlhost1 –username=nagiosuser –password=nagiospass –mode connected-users