在Linux和Azure数据库freetds的，登录问题 [英] freeTDS on Linux and Azure database, login issue

问题描述

我尝试连接到Azure数据库，如：

I try to connect to Azure database like:

 tsql -H XXXXXX.database.windows.net -p 1433 -U mycorrectusername

但我得到的消息

Msg 20004, Level 9, State 0, Server OpenClient, Line 0
Read from SQL server failed.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server

这可能是我不能登录，因为我可以先选择数据库。我有，当我通过网站登录。

It is possible that I cant login because I have to choose database first. I have to, when I log in via website.

当我尽量选择像数据库：

When I try to choose database like:

tsql -H XXXXXXXXX.database.windows.net -p 1433 -U username -D databasename

但我得到的消息：

but I get message:

tsql: illegal option -- D

下面是TSQL配置：

[~]$ tsql -C
Compile-time settings (established with the "configure" script):
                       Version: freetds v0.64
MS db-lib source compatibility: yes
   Sybase binary compatibility: unknown
                 Thread safety: yes
                 iconv library: yes
                   TDS version: 5.0
                         iODBC: no
                      unixodbc: no

感谢您的任何建议。

推荐答案

这是不可能与Azure数据库与freetds的v0.64连接。解决的办法是编译最新freetds的版本，目前0.91。来源是avalible这里：

It is not possible to connect with Azure database with FreeTDS v0.64. The solution is to compile the newest freetds version, currently 0.91. The sources are avalible here:

https://gitorious.org/freetds/freetds/source/a6898bdd6fa115447366ddbc76830e6826ea5d21:

和与DBLIB源兼容性选项毫秒（和TLS或OpenSSL，以便进行加密连接），编译它。

and compile it with ms dblib source compatibility option (and tls or openssl for the encrypted connection).

这篇关于在Linux和Azure数据库freetds的，登录问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！