以下是在Ubuntu上配置SQL Server的步驟:
sudo apt update
,sudo apt upgrade
。curl -fsSL https://packages.microsoft.com/keys/microsoft.asc | sudo gpg --dearmor -o /usr/share/keyrings/microsoft-prod.gpg
。curl -fsSL https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list | sudo tee /etc/apt/sources.list.d/mssql-server-2022.list
。sudo apt-get update
,sudo apt-get install -y mssql-server
。sudo /opt/mssql/bin/mssql-conf setup
,按提示設置SA密碼并選擇版本。sudo systemctl start mssql-server
,sudo systemctl enable mssql-server
。sudo ufw allow 1433/tcp
,sudo ufw reload
。