在linux上安装 sql server for linux
Install SQL Server on Red Hat Enterprise Linux
Install SQL Server
To install the mssql-server package on RHEL, follow these steps:
-
Enter superuser mode.
Copybash
sudo su
-
Download the Microsoft SQL Server Red Hat repository configuration file:
Copybash
curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo > /etc/yum.repos.d/mssql-server.repo
-
Exit superuser mode.
Copybash
exit
-
Run the following commands to install SQL Server:
Copybash
sudo yum install -y mssql-server
-
After the package installation finishes, run the configuration script and follow the prompts. Make sure to specify a strong password for the SA account (Minimum length 8 characters, including
uppercase and lowercase letters, base 10 digits and/or non-alphanumeric symbols).Copybash
sudo /opt/mssql/bin/sqlservr-setup
-
Once the configuration is done, verify that the service is running:
Copybash
systemctl status mssql-server
-
You may need to open a port on the firewall on RHEL. If you are using FirewallD for your firewall, you can use the following commands.
Copybash
sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent
sudo firewall-cmd --reload