- 1.安装SQLServer安装成功
root# systemctl status mssql-server.service <br>
● mssql-server.service - Microsoft SQL Server Database Engine<br>
Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)<br>
Active: active (running) since Mon 2018-11-26 18:06:30 CST; 15min ago<br>
Docs: https://docs.microsoft.com/en-us/sql/linux<br>
Main PID: 786 (sqlservr)<br>
Tasks: 163<br>
Memory: 1.9G<br>
CGroup: /system.slice/mssql-server.service<br>
├─ 786 /opt/mssql/bin/sqlservr<br>
└─1011 /opt/mssql/bin/sqlserv
- 2.系统是Fedora-Server-29,SQLServer版本2019用的是红帽的安装文档
https://docs.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-red-hat?view=sql-server-201
- 3.本地连接SQLServer报错<br>
[root@Fedora-Server ~]# sqlcmd -S localhost -U SA
Password:
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2746.<br>
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Client unable to establish connection.<br>
root# systemctl status mssql-server.service <br>
● mssql-server.service - Microsoft SQL Server Database Engine<br>
Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)<br>
Active: active (running) since Mon 2018-11-26 18:06:30 CST; 15min ago<br>
Docs: https://docs.microsoft.com/en-us/sql/linux<br>
Main PID: 786 (sqlservr)<br>
Tasks: 163<br>
Memory: 1.9G<br>
CGroup: /system.slice/mssql-server.service<br>
├─ 786 /opt/mssql/bin/sqlservr<br>
└─1011 /opt/mssql/bin/sqlserv
- 2.系统是Fedora-Server-29,SQLServer版本2019用的是红帽的安装文档
https://docs.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-red-hat?view=sql-server-201
- 3.本地连接SQLServer报错<br>
[root@Fedora-Server ~]# sqlcmd -S localhost -U SA
Password:
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2746.<br>
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Client unable to establish connection.<br>