Monday, July 14, 2008

Nagios and MSSQL 2005

Recently some of the hosts that I monitor and provide server administration support upgraded their MSSQL 2000 to MSSQL 2005. The problem started when we tried to add MSSQL 2005 database service to monitoring. Nagios would simply not check "MSSQL$SQLEXPRESS" and return a Unknown state. Obviously the $ in the middle of the service name was causing the issue. Found out later that we need to use either two $$ or quote the dollar sign so that it shows MSSQL$"$"SQLEXPRESS.

1 Comments:

At November 11, 2008 12:45 AM , Anonymous Anonymous said...

Vishal - This resolved my issue, however I had to put it inside single quotes in order for it to work. The one that worked for me was: 'MSSQL$$EXPRESS'

 

Post a Comment

<< Home