Biztalk - Auth via AD

Overview

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