CentOS 7.6安装SQL Server 2019
CentOS 7.6安装SQL Server 2019预览版
安装SQL Server
curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-preview.repo
yum install -y mssql-server
安装命令行工具
curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repo yum remove -y unixODBC-utf16 unixODBC-utf16-devel yum install -y mssql-tools unixODBC-devel
命令加入环境变量
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc source ~/.bashrc
配置SQL Server
/opt/mssql/bin/mssql-conf setup
usermod: no changes Choose an edition of SQL Server: 1) Evaluation (free, no production use rights, 180-day limit) 2) Developer (free, no production use rights) 3) Express (free) 4) Web (PAID) 5) Standard (PAID) 6) Enterprise (PAID) 7) Enterprise Core (PAID) 8) I bought a license through a retail sales channel and have a product key to enter. Details about editions can be found at https://go.microsoft.com/fwlink/?LinkId=852748&clcid=0x409 Use of PAID editions of this software requires separate licensing through a Microsoft Volume Licensing program. By choosing a PAID edition, you are verifying that you have the appropriate number of licenses in place to install and run this software. Enter your edition(1-8): 2
The license terms for this product can be found in /usr/share/doc/mssql-server or downloaded from: https://go.microsoft.com/fwlink/?LinkId=855862&clcid=0x409 The privacy statement can be viewed at: https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409 Do you accept the license terms? [Yes/No]:yes
Enter the SQL Server system administrator password: Confirm the SQL Server system administrator password: Configuring SQL Server... This is an evaluation version. There are [172] days left in the evaluation period. ForceFlush is enabled for this instance. ForceFlush feature is enabled for log durability. Created symlink from /etc/systemd/system/multi-user.target.wants/mssql-server.service to /usr/lib/systemd/system/mssql-server.service. Setup has completed successfully. SQL Server is now starting.
确保为SA帐户指定强密码(最少8个字符,包括大写和小写字母、十进制数字和/或非字母数字符号)
检查
systemctl status mssql-server
rpm -qa | grep mssql find / -name mssql
开启防火墙端口
firewall-cmd --zone=public --add-port=1433/tcp --permanent firewall-cmd --reload
下载Azure Data Studio
https://github.com/Microsoft/azuredatastudio https://docs.microsoft.com/zh-cn/sql/azure-data-studio/download?view=sql-server-2017
验证模式选择SQL Login,用户名SA和复杂性密码登录
本站所有文章均可随意转载,转载时请保留原文链接及作者。