在Ubuntu下安装SQL Server^参考

安装 SQL Server

导入公共存储库 GPG 密钥

1
2
3
sudo apt-get install curl
curl -fsSL https://packages.microsoft.com/keys/microsoft.asc | sudo gpg --dearmor -o /usr/share/keyrings/microsoft-prod.gpg
sudo cp /usr/share/keyrings/microsoft-prod.gpg /etc/apt/trusted.gpg.d/

注册 SQL Server Ubuntu 存储库

1
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

运行以下命令以安装 SQL Server

1
2
sudo apt-get update
sudo apt-get install -y mssql-server

设置 SA 密码

1
sudo ACCEPT_EULA='Y' MSSQL_PID='Developer' MSSQL_SA_PASSWORD='1q2w3e4rQWE!' MSSQL_TCP_PORT=1433 /opt/mssql/bin/mssql-conf setup

完成配置后，验证服务是否正在运行

1
systemctl status mssql-server --no-pager

安装 SQL Server 命令行工具

注册 Microsoft Ubuntu 存储库

1
curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list | sudo tee /etc/apt/sources.list.d/ms-prod.list

更新源列表，并使用 unixODBC 开发人员包运行安装命令

1
2
sudo apt-get update
sudo apt-get install -y mssql-tools18 unixodbc-dev

启动服务

1
2
sudo /opt/mssql/bin/mssql-conf set sqlagent.enabled true
sudo systemctl restart mssql-server