CentOS Install the SQL Server vnext CTP1 tutorial _mssql

Today, Microsoft officially released the SQL Server 2016 SP1, according to the previous SP1 law, can be used in the production environment. The standard version of SP1 will have almost all the features of the Enterprise Edition. Only environments with more than 128GB of RAM or more than 24 cores or more than 4 roads must have an enterprise version installed.

There is also an important release: SQL Server vnext on Linux. This is also the version of the installation that this article describes. Long story short, start the installation.

For this version of SQL Server, the official support platform is red Hat enterpise 7.2 or Ubuntu 16.04. But I don't have red Hat for the moment, so try it with CentOS 7.2. I was installed as root.

1. Installation

#下载库配置文件
Curl Https://packages.microsoft.com/config/rhel/7/mssql-server.repo >/etc/yum.repos.d/ Mssql-server.repo
#安装
sudo yum install-y mssql-server

2. Run the configuration file

Configure the configuration file for the #运行SQL server.
#这个过程会要你同意License条款, set the sa password, set the SQL Server service to boot

/opt/mssql/bin/sqlservr-setup

3. Check Service status

#检查SQL Server's service status

systemctl status Mssql-server

4. Modify the Firewall

#修改防火墙, allow 1433-port

systemctl start firewalld
firewall-cmd--zone=public--add-port=1433/tcp--permanent
Firewall-cmd--reload

5. Install SQL tools, including SQLCMD and bcp

#下载源的库配置文件

Curl Https://packages.microsoft.com/config/rhel/7/prod.repo >/etc/yum.repos.d/msprod.repo

#安装tools
Yum Install Mssql-tools

6. Connection test

# Use SQLCMD's local connection. Enter the password directly after the-p parameter or after the return entry.

sqlcmd-s-U sa-p

Sqlcmd is found to be used in the same way as Windows. The return content finally has a volume per second of transactions based on the time-consuming estimate of the current query.

Then build a library, build a table to try.

Remote connection. Using sqlcmd from Windows, using an extranet IP connection

With the SSMS connection, I use the SQL 2014 installation with SSMS, there may be some unsupported issues. You can see that the agent did not start, actually this version does not have an agent.

Interestingly, you can create a library using SSMS, but you cannot create a table. From the error message, it seems that the graphical interface creation table is not supported.

Summarize:

Test it a little bit and have the opportunity to test more features. Agent, replication, and most of the bi functional components are not currently supported.
A lot of people are looking forward to SQL Server on Linux. If its performance on Linux is as good as it used to be on windows, I'm sure more people will use it.
More documentation on Linux for SQL Server: SQL Server on Linux documentation

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.