CentOS 7 Installation SQL Server

In our traditional understanding that SQL can only be installed in Windows systems, but now Microsoft also embraced Linux, the emergence of SQL for Linux version, although currently a technical preview version, but in the near future will appear in the official commercial version. So today I will take you to install once, here I choose the system is CentOS 7, in my such a perennial play windows and very familiar with the windows of the people need to use the full command of CentOS or very novice, so also ask you the Linux great God to forgive. I take the most fool of the way with everyone steps from the system to the installation of SQL to go through, I believe that the future of users with this need is very helpful.

Well, then, here I used vmwareworkstation to create a 1vcpu,3g memory, 20G hard disk virtual machine, put into CentOS7 CD to start the installation system.

Select Install CentOS7

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M02/99/0A/wKioL1lDTrigAFQiAABg3aFbfg4699.png "height=" 467 "/>

Waiting for a bunch of tests to start running

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M01/99/0A/wKiom1lDTrnz-vdJAAFxMEC9_NQ828.png "height=" 443 "/>

Select the installation language here and click Continue

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M00/99/0A/wKioL1lDTrrTjW7PAAG2j3FjBPo541.png "height=" 484 "/>

The following section defaults to

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M01/99/0A/wKioL1lDTrvQfg8yAAHwfXChTjE555.png "height=" 484 "/>

The following location is required to set the next

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M02/99/0A/wKiom1lDTrzRwjl2AACXaRuk-B8215.png "height=" 207 "/>

Installation location is to choose our hard drive, here I choose all the space, kdump I do not need to debug what, network and hostname set up a fixed IP address and host name

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M02/99/0A/wKioL1lDTr3j1JFQAAFwPVLb_Iw609.png "height=" 482 "/>

After the setup is complete, click "Finish" to start the installation.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M00/99/0A/wKioL1lDTr_xyE_BAAHp5Nrze94901.png "height=" 484 "/>

You only need to set the root password during installation

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M00/99/0A/wKiom1lDTsLw1IQRAAL8Q7ilkqY903.png "height=" 484 "/>

Wait for the rest of the installation to complete

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M01/99/0A/wKiom1lDTsWgckePAALdFKkpl3Q814.png "height=" 483 "/>

Installation Complete, restart

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M02/99/0A/wKiom1lDTseAOEojAAGOc50mZXw124.png "height=" 483 "/>
After the installation is complete, CentOS needs to access the Internet, use a network installation, log on as root, and if not the root user, sudo is required to run.

You need to know this site before you install SQL https:// Packages.microsoft.com, in this site to store the respective Linux branch version of the corresponding SQL configuration files and installation files, I will call here to download the installation, of course, if you do not have access to the Internet can be downloaded in advance of these files for offline installation is OK.

CentOS starts quickly, without installing GUI components, which naturally belongs to the time of the command-knocking.

650) this.width=650; "title=" clip_image001 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image001" src= "http://s3.51cto.com/wyfs02/M02/99/0A/wKioL1lDTsfCWmqGAAAvpORSS-w762.png" height= "/>"

Input Curl Https://packages.microsoft.com/config/rhel/7/mssql-server.repo >/etc/yum.repos.d/ Mssql-server.repo start downloading the relevant configuration file after you enter the car

650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image002" src= "Http://s3.51cto.com/wyfs02/M02/99/0A/wKioL1lDTsnjtGXcAAEDukaQZV0515.png" height= "338"/>

650) this.width=650; "title=" clip_image003 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image003" src= "http://s3.51cto.com/wyfs02/M00/99/0A/wKioL1lDTsqh10RrAABmZWk5OhU472.png" height= "/>"

Download complete and install SQL complete

650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image004" src= "http://s3.51cto.com/wyfs02/M01/99/0A/wKioL1lDTsuhQElwAADwFgzeN2s560.png" height= "337"/>

Wait for the download to complete, after the download is complete, configure SQL Sudo/opt/mssql/bin/mssql-conf Setup

and set the SQL sa account password, the input SA is not displayed, so it belongs to the blind dozen (do not care about these details)

650) this.width=650; "title=" clip_image005 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image005" src= "Http://s3.51cto.com/wyfs02/M02/99/0A/wKioL1lDTszjecY4AAB6WkIQi78394.png" height= "133"/>

And I'll tell you this is an evaluation version, and there's a 147-day evaluation period.

650) this.width=650; "title=" clip_image006 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image006" src= "http://s3.51cto.com/wyfs02/M01/99/0A/wKioL1lDTs2iWH04AAA6_EzS6YQ567.png" height= "/>"

Here our SQL Main program is installed to complete the

We can look at the status of the SQL service

Systemctl Status Mssql-server

650) this.width=650; "title=" clip_image007 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image007" src= "Http://s3.51cto.com/wyfs02/M02/99/0A/wKioL1lDTs6RzdEXAAEVptPTtU8053.png" height= "208"/>

Next, if we need to use this CentOS SQL from another computer then we need to open the firewall port 1433 of the Centossql host.

sudo firewall-cmd--zone=public--add-port=1433/tcp--permanent
sudo firewall-cmd--reload

650) this.width=650; "title=" clip_image008 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image008" src= "http://s3.51cto.com/wyfs02/M02/99/0A/wKiom1lDTs-iR-AAAAA2etW7Kog115.png" height= "/>"

If you want to upgrade the SQL software package, follow

sudo yum update mssql-server

These commands will download the latest package and replace the binaries below/opt/mssql/. User-generated databases and system databases are not affected by this operation.

650) this.width=650; "title=" clip_image009 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image009" src= "Http://s3.51cto.com/wyfs02/M01/99/0A/wKiom1lDTtDi5iuwAABlWs3lXXY753.png" height= "129"/>

This article is from the "Zjunsen Cloud computing" blog, so be sure to keep this source http://rdsrv.blog.51cto.com/2996778/1937388

CentOS 7 Installation SQL Server