freetds not able to connect to MSSQL DB from Linux (Ubuntu)

There were two things preventing me from connecting:
– I did not have the correct port. Found this using: tsql -LH IPAddress
– Then I was stuck. Finally found the post below. You have to have a freetds config file in the home directory. Somthing like this:


awesomeserver:~$ less .freetds.conf
[global]
    # TDS protocol version
    tds version = 7.0

helped by:
http://stackoverflow.com/questions/7590944/freetds-connection-problems-on-linux?answertab=active#tab-top