试图通过命令
连接远程MSSQL服务器tsql -S SQLEXPRESS -U sa
passwod: sa它会抛出如下错误错误20009(严重程度9):无法连接:Adaptive Server不可用或不存在操作系统错误111,"Connection refused"
步骤1/etc/freetds/freetdsconf.conf
[SQLEXPRESS]
host = 192.168.1.9
port = 1433
tds version = 8.0
client charset = UTF-8
/etc/odbcinst.ini
[FreeTDS]
Description = TDS driver (Sybase/MS SQL)
Driver =/usr/lib/i386-linux-gnu/odbc/libtdsodbc.so
Setup =/usr/lib/i386-linux-gnu/odbc/libtdsS.so
CPTimeout =
CPReuse =
FileUsage = 1
etc/odbc.ini
[SQLEXPRESS]
Driver = FreeTDS
Description = ODBC connection via FreeTDS
Trace = No
Servername = 192.168.1.9
Database = cakephp_results
Port = 1433
UID = sa
PWD = sa
ReadOnly = No
在您的odbc.ini文件中将'Servername = '更改为'Server = '。然后暂时从该文件中删除UID、PWD和只读行。您可能需要将它们全部删除,并从您的应用程序中传入凭据。
然后,确保您的MSSQL数据库允许通过端口1433连接,SQL Server没有阻止传入服务器的IP地址,并且您有正确的密码。
此外,如果这不起作用,请查看以下故障排除说明: