以下是在Debian上設置SQL Server遠程連接的步驟:
sudo apt update
sudo apt install mssql-server
mssql -conf工具:sudo mssql -conf set network.tcpip_enabled true
sudo mssql -conf set network.tcp_port 1433
sudo systemctl restart mssql -server
/etc/sqlserver/sqlserver.conf,確保[network]部分tcpip = true且tcpport = 1433,然后重啟服務。ufw:sudo ufw allow 1433/tcp
sudo ufw reload
iptables:sudo iptables -A INPUT -p tcp --dport 1433 -j ACCEPT
sudo service iptables save
sudo systemctl restart iptables
sqlcmd執行命令:EXEC sp_configure 'remote access', 1;
RECONFIGURE;
sqlcmd -S <服務器IP>,1433 -U SA -P <密碼>