[unixODBC][FreeTDS][SQL Server]Unable to connect to data source
<p>Im using Debian machine and I was trying to connect to remote sql server, but encounter the error when I try to connect via isql:</p>

<pre><code>root@debian:~/installtest# isql -v SQLServer-Conn
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[37000][unixODBC][FreeTDS][SQL Server]Login failed for user ''.
[ISQL]ERROR: Could not SQLConnect
</code></pre>

<p>Here is my odbc.ini</p>

<pre><code>[SQLServer-Conn]
Description=MS SQL connection to remote db
Driver=FreeTDS
Server=10.xx.xx.xx
Port=49xxx
User=username
Password=password
Database=remotedb
Trace=No
</code></pre>

<p>Here is my odbcinst.ini</p>

<pre><code>[FreeTDS]
Description = ODBC for SQL Srv
Driver      = /usr/lib/i386-linux-gnu/odbc/libtdsodbc.so
Setup       = /usr/lib/i386-linux-gnu/odbc/libtdsS.so
UsageCount  = 1
</code></pre>

<p>The db was fine as I was able to connect using this same machine via tsql command. So i'm not sure if im missing something on the .ini files
Thanks for the help</p>