Shulou(Shulou.com)05/31 Report--

This article is about how to install SQL Server vNext CTP 1.2 on CentOS 7.3.This article is about how to install it. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

SQL Server vNext CTP 1.2 installation tutorial:

This installation process refers to Microsoft's official installation documentation: https://docs.microsoft.com/zh-tw/sql/linux/sql-server-linux-overview

Supported environments:

Microsoft officially suggested that installing SQL Server on Linux requires at least the memory of 3.25GB, otherwise the configuration will fail.

For ease of use, CentOS Linux release 7.3.1611 is used here, and the memory of 4GB is configured. You can also choose the appropriate version according to your actual situation.

Because it is a network download and installation, please make sure that the network is connected before doing the following, otherwise an error similar to the following will occur:

Failed to get GPG key: [Errno 14] curl#6-"Could not resolve host:packages.microsoft.com; unknown name or service"

0curl: (6) Could notresolve host: packages.microsoft.com; unknown error

Download Microsoft SQL Server Red Hat repository configuration file: (configure yum source)

[root@localhost ~] # curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo > / etc/yum.repos.d/mssql-server.repo

Total Received Xferd Average Speed TimeTime Time Current

Dload UploadTotal Spent LeftSpeed

100220 2200 0 3410-

Install through a user with root privileges:

[root@localhost ~] # yum install mssql-server

[root@localhost ~] # / opt/mssql/bin/sqlservr-setup

Here, set the password of the SA user, whether to start the SQL Server service now, and whether to set SQL Server to boot automatically.

It should be noted that if the configured memory does not meet the requirements, the configuration will fail:

Just reconfigure it after adding memory! If you installed Linux in a virtual machine, you need to shut down before you can add more memory (above 3GB).

At this point, SQL Server has been installed! Since it is installed on a Linux system, you certainly need to manage the database through the command line mode. Oracle has sqlplus,SQL Server and sqlcmd, but it needs to be installed separately.

Configure the yum source first:

[root@localhost ~] # curl https://packages.microsoft.com/config/rhel/7/prod.repo > / etc/yum.repos.d/msprod.repo

[root@localhost ~] # yum update

The process is a bit long.

[root@localhost ~] # yum update mssql-tools

[root@localhost bin] # sqlcmd-S localhost-U SA-P

All right, SQL Server on Linux has been installed!

Thank you for reading! This is the end of this article on "how to install SQL Server vNext CTP 1.2 on CentOS 7.3.I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!"

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.