Nagios Support Forum

Yes, sorry it took me a long time to see your post. Thanks a lot. It's solved!!!

Yes, I should have put sap_gbg instead of my_server in the brackets. Thanks again.

Now it works!!! Thanks a lot to everybody who helped me through this issue. I will record here what I did on this last step so other people facing the same situation can benefit from this post. I defined the name of the "server" at /etc/freetds/freetds.conf: [my_server] host = 10.0.0.29 po...

Hi, I've just tried and got the same result from Nagios and from command line: Status Information: CRITICAL - cannot connect to 10.0.0.29. DBI connect(':server=10.0.0.29','sa',...) failed: OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (41) Server 10.0.0.29, database Message S...

I checked the link and the problem is really very similar. I checked the freetds.conf (I have two of them, one on /usr/local/etc and the other on /etc/freetds) and it is as posted: # TDS protocol version ; tds version = 8 (MINE WAS 4.2 and I edited it to 8..) [sqlhost1] server = 10.0.0.29 port = 143...

I've checked that link but could not find anything new. Answering your question, yes, I've opened both tcp port 1433 and udp 1434. Also, following the link you sent, I've also opened windows firewall outbound rules for any port/ip that communicates with the sql server. After creating that rule, I've...

I hope I've made a progress by following the link http://blog.citrix24.com/configure-sql-express-to-accept-remote-connections/ because now the nmap command shows the port is open: ubuntu@ip-10-0-0-10:~$ sudo nmap 10.0.0.29 -p 1433 Starting Nmap 5.21 ( http://nmap.org ) at 2015-09-04 16:24 UTC Nmap s...

I've turned off the windows firewall (the aws firewall allows connections through port 1433) and the nmap command responded differently: ubuntu@ip-10-0-0-10:~$ sudo nmap 10.0.0.29 -p 1433 Starting Nmap 5.21 ( http://nmap.org ) at 2015-09-04 14:13 UTC Nmap scan report for ip-10-0-0-29.ec2.internal (1...

I've installed nmap and got the following result: ubuntu@ip-10-0-0-10:~$ sudo nmap 10.0.0.29 -p 1433 Starting Nmap 5.21 ( http://nmap.org ) at 2015-09-03 23:48 UTC Nmap scan report for ip-10-0-0-29.ec2.internal (10.0.0.29) Host is up (0.00016s latency). PORT STATE SERVICE 1433/tcp filtered ms-sql-s ...

Sorry because I had not noted that you replied.. now I see there is page 2 for this post. I tried sudo namp 10.0.0.29 -p 1433 and got a "command not found" message from ubuntu. How can I run that command from the ubuntu prompt? do I need to change any permission for the ubuntu user? as thi...