sql-server - Linux 上的 SQL Server : Data source name not found

Question

我关注了 instructions在我的机器上本地安装 Sql server，它运行基于 ubuntu xenial 的 linux mint sonya。

我在安装服务时没有遇到任何问题:

$ systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
   Loaded: loaded (/lib/systemd/system/mssql-server.service; disabled; vendor preset: enabled)
   Active: active (running) since Wed 2017-09-27 17:13:12 PDT; 18s ago
     Docs: https://learn.microsoft.com/en-us/sql/linux
 Main PID: 4139 (sqlservr)
    Tasks: 158
   Memory: 877.1M
      CPU: 4.543s
   CGroup: /system.slice/mssql-server.service
           ├─4139 /opt/mssql/bin/sqlservr
           └─4150 /opt/mssql/bin/sqlservr

尝试连接数据库时，出现此错误:

$ sqlcmd -S localhost
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Data source name not found, and no default driver specified.

Answer 1

毕竟我没有安装 unixodbc-dev 包。错误消息有点让我失望。