Installation tutorial of SQL Server vNext CTP 7.3 on CentOS 1.2,

Installation tutorial of SQL Server vNext CTP 7.3 on CentOS 1.2,

SQL Server vNext CTP 1.2 installation Tutorial:

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

Supported environments:

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

For ease of use, here we use CentOS Linux release 7.3.1611, with 4 GB memory configured, you can also select the appropriate version based on your actual situation.

Before you perform the following operations, make sure that the network is accessible. Otherwise, the following errors may occur:

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

0 curl: (6) cocould notresolve host: packages.microsoft.com; Unknown error

Download the Microsoft SQL Server RedHat repository configuration file: (configure the 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 Time Current

Dload Upload Total Spent Left Speed

100 220 100 220 0 0 341 0 --: -- 341

Install the SDK through a user with root permissions:

[Root @ localhost ~] # Yum install mssql-server

[Root @ localhost ~] #/Opt/mssql/bin/sqlservr-setup

Set the SA user password, whether to start the SQL Server service, and whether to enable the SQL Server startup.

Note that the configuration fails if the configured memory does not meet the requirements:

Add the memory and then reconfigure it! If Linux is installed in a virtual machine, you need to shut down before you can add large memory (more than 3 GB ).

So far, SQL Server has been installed! Since it is installed on Linux, you must use the command line mode to manage the database. Oracle has sqlplus and SQL Server has sqlcmd, but you need to install it 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

This 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!

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.