MSSQL installation in Redhat/CentOS 7

MSSQL installation in Redhat/CentOS 7

As Microsoft continues to develop towards Linux, from the beginning of Bash on Ubuntu on Windows (see for Ubuntu on Windows installation in Windows) to the current leadership of Microsoft under Satya Nadella, microsoft has made significant progress in the Linux-dominated industry (such as the fast-pushing of Cloud Technologies) by the giants of Redmond (the headquarters of Microsoft in the United States. Enabling SQL Server to run in a Linux environment is another symbolic action of this process. Of course, no matter what motivation Microsoft has behind this initiative, but currently msSQL can be run on Red Hat EnterpriseLinux 7 (including CentOS 7) and Ubuntu server 16.04, however, you must note that the running server requires 3.25 GB of memory. The following describes how to install MSSQL in CentOS 7:

[root@localhost ~] # cd /etc/yum.repos.d/ [root@localhost yum.repos.d] # wget https://packages.microsoft.com/config/rhel/7/mssql-server.repo [root@localhost yum.repos.d] # yum -y install mssql-server [root@localhost yum.repos.d] # /opt/mssql/bin/mssql-conf setup You can find the license terms for this product in the following locations: /usr/share/doc/mssql-server  Or download from: https: //go .microsoft.com /fwlink/ ?LinkId=852741&clcid=0x804  You can view the privacy statement from the following locations: https: //go .microsoft.com /fwlink/ ?LinkId=853010&clcid=0x804  Do you accept this license? [Yes /No ]: yes  Select a version of SQL Server:   1) evaluation version (free, no production license, 180-day limit)   2) Developer Edition (free, no Production License)   3) Express (free)   4) Web edition (paid)   5) Standard Edition (paid)   6) Enterprise Edition (paid)   7) I have purchased a license through the retail channel and have the product key to be entered.  You can find the version details in the following locations: https: //go .microsoft.com /fwlink/ ?LinkId=852748&clcid=0x804  To use the paid version of this software, you must obtain separate authorization through the following channels: Microsoft batch license plan. If you select the paid version, it indicates that you have the applicable The number of local licenses to install and run the software.  Input version (1-7): 2  Select the language of SQL Server: (1) English (2) Deutsch (3) Español   ) Français ▽5) Italiano (6) Japanese Region (7) 한국어 (8) Português (9) Русский (10) Chinese-Simplified (11) Chinese (traditional) Enter Option 1-11: 10 Enter the SQL Server system administrator password: Confirm the SQL Server system administrator password: Configuring SQL Server...  This is an evaluation version.  There are [17] days left  in  the evaluation period. Created  symlink  from  /etc/systemd/system/multi-user .target.wants /mssql-server .service to  /usr/lib/systemd/system/mssql-server .service. The installation has been completed successfully. SQL Server is starting.

After such simple configuration and installation, msSQL is installed on CentOS 7. Note that the default port 1433 of msSQL must be enabled on the server, then, when installing msSQL, the system will prompt you to configure the sa password as prompted. After the sa password is configured, msSQL will be started, after msSQL is installed, a new user of mssql will be added to the system in the/opt/mssql path. The user's home directory is/var/opt/mssql, msSQL-related data files and logs are stored.