If you have a biztalk server using windows AD Authentication instead of a SQL user you will need to do the following:
- change -H to -S in the check
- -U 'DOMAIN\username'
- edit /etc/freetds.conf * Add your host according to the following layout
[name_to_be_used_after_-S_flag] host = <hostname> port = 1433 tds version = 8.0
Contributed by MR