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

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

For this version of SQL Server, the officially supported platform is Red Hat Enterpise 7.2 or Ubuntu 16.04. But I don't have Red Hat on hand at the moment, so I'll try CentOS 7.2. I installed it as root.

1. Installation

# download the 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

two。 Running configuration file

# run the configuration file of SQL Server for configuration. # this process will require you to agree to the License terms, set the SA password and set the SQL Server service boot / 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's 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 enter the password after entering the enter. Sqlcmd-S. -U SA-p

It is found that sqlcmd is used in the same way as under windows. At the end of the return, there is an estimated number of transactions per second based on the time spent of the current query.

Then build a library and try to build a table.

Remote connection. Use sqlcmd from windows and connect with public network IP

Using SSMS connection, I use SQL 2014 to install with SSMS, there may be some unsupported issues. You can see that Agent does not start, in fact, this version does not have Agent.

Interestingly, you can create libraries with SSMS, but not tables. Judging from the error message, it seems that the graphical interface does not support the creation of tables.

Thank you for reading! This is the end of this article on "how to install SQL Server vNext CTP1 in CentOS". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out 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.