freetds连接问题macOS

Question

我正在尝试从MacOS连接到远程MSSQL DB。

我可以使用freetds连接到远程数据库

tsql -H servername.database.windows.net -U username -P password -D database_name -p 1433

但是，当我使用以下设置在/usr/local/etc/freetds.conf文件中输入条目时

[dbservername]
    host = servername.database.windows.net
    port = 1433
    database = database_name
    tds version = 7.3

并尝试使用以下命令连接

tsql -S dbservername -U username -P password

我得到以下错误

locale is "C/UTF-8/C/C/C/C"
locale charset is "UTF-8"
using default charset "UTF-8"
 2Msg 40532 (severity 20, state 1) from dbservername:
    "Cannot open server "dbservername" requested by the login.  The login failed."
Error 20002 (severity 9):
    Adaptive Server connection failed
There was a problem connecting to the server

tsql -C输出

Compile-time settings (established with the "configure" script)
                        Version: freetds v1.00.48
         freetds.conf directory: /usr/local/Cellar/freetds/1.00.48/etc
 MS db-lib source compatibility: no
    Sybase binary compatibility: no
                  Thread safety: yes
                  iconv library: yes
                    TDS version: 7.3
                          iODBC: no
                       unixodbc: no
          SSPI "trusted" logins: no
                       Kerberos: no
                        OpenSSL: yes
                         GnuTLS: no
                           MARS: no

你知道怎么解决这个问题吗？

Answer 1

问题是FreeTDS正在不同的目录中查找您的配置文件。tsql -C显示它期望文件是/usr/local/Cellar/freetds/1.00.48/etc格式的。

将freetds.conf从/usr/local/etc/移动到/usr/local/Cellar/freetds/1.00.48/etc，然后再试一次。祝好运!

Answer 2

回答有点晚了，但需要将用户名写为：

username@servername

连接到Azure数据库时(Azure中的sqlserver)