CentOS installation of SQL Server vNext CTP1 tutorial, centosctp1

CentOS installation of SQL Server vNext CTP1 tutorial, centosctp1

Today, Microsoft officially released SQL Server 2016 SP1, which can be used in the production environment according to the previous SP1 law. The Standard Edition with SP1 will have almost all functions of the Enterprise Edition. The Enterprise Edition must be installed only when RAM exceeds GB, 24 cores, or 4 cores.

Another important release is SQL Server vNext on Linux. This document also describes the installed version. In short, start installation.

This version of SQL Server officially supports Red Hat Enterpise 7.2 or Ubuntu 16.04. But I have no Red Hat at the moment, so I will try CentOS 7.2. I installed it as root.

1. Install

# Download library configuration file curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo>/etc/yum. repos. d/mssql-server.repo # install sudo yum install-y mssql-server

2. Run the configuration file

# Run the SQL Server configuration file for configuration. # This process requires you to agree to the License terms, set the SA password, set the SQL Server service to start/opt/mssql/bin/sqlservr-setup

3. Check service status

# Check the service status of SQL Server systemctl status mssql-server

4. Modify the Firewall

# Modify the firewall to allow port 1433 systemctl start firewalldfirewall-cmd -- zone = public -- add-port = 1433/tcp -- permanentfirewall-cmd -- reload

5. Install SQL tools, including sqlcmd and bcp

# Download the source library configuration file curl https://packages.microsoft.com/config/rhel/7/prod.repo>/etc/yum. repos. d/msprod. repo # install toolsyum install mssql-tools

6. connection test

# Use the local connection of sqlcmd. Enter the password directly after the-P parameter or press enter and enter the password. Sqlcmd-S.-u sa-p

It is found that sqlcmd is used in the same way as windows. At the end of the returned content, there is a transaction volume per second estimated based on the time consumed by the current query.

Create a database and create a table.

Remote connection. Use sqlcmd in windows and connect with an Internet IP Address

When using SSMS connection, I use SQL 2014 with SSMS, which may cause some unsupported problems. We can see that the Agent has not been started. In fact, this version does not have an Agent.

Interestingly, you can use SSMS to create databases, but not tables. According to the error message, it seems that the graphic interface is not supported to create tables.

Summary:

Test more functions in an early taste. Currently, edas does not support Agent, replication, and most BI functional components.
Many people are looking forward to SQL Server On Linux. If the performance of Linux is as good as that of Windows in the past, I believe more people will use it.
More about SQL Server On Linux: SQL Server on Linux Documentation

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