We're doing MsSQL checks (wrote our own checker). It's not much, but all it does is checks to see what the srvname from the sysservers table in the "master" database is set to:
select srvname from sysservers where srvid = 0
It should return the name of the server and the main DB name, so like this:
HOSTNAME\DB_NAME
HOSTNAME is the host, and DB_NAME is the actual Database.
We run it on Solaris as a remote test and use the Sybase Perl DBD/DBI module.
---Eric
-----Original Message----- From: L.M.J. [mailto:linuxmasterjedi at free.fr] Sent: Tuesday, December 04, 2007 07:41 To: hobbit at hswn.dk Subject: [hobbit] dbcheck.pl + MsSQL monitoring
Hello guys,
I'm wondering if someone already checking MsSQL databases. I'm curious about each step to monitor it. I've installed freetds and wrote that : [myMySQL_DB] host = bahia.latecoere.gl.local port = 1433 tds version = 7.0
Netapp.ini: [myMySQL_DB] dbtype = SQLServer hostname = MsSQLServer1 port = 1433 username = hobbit password = hobbitpwd
bb-hosts group MsSQL 0.0.0.0 myMySQL_DB # noconn noping dbcheck NAME:"CE" DESCR:"MsSQLServer1:"
But it doesn't work, I have this error :
Connection failed with unknown error for"DBI:Sybase:host=bahia;port=1433;encryptPassword=1"!
Anyone could have an idea why ?
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk