Shulou(Shulou.com)06/01 Report--

What the editor wants to share with you this time is how to install SQLServer2019 in CentOS8. The article is rich in content. Interested friends can learn about it. I hope you can get something after reading this article.

1. Download the Microsoft SQL Server 2019 Red Hat repository configuration file

two。 Run the following command to install SQL Server:

# yum install-y mssql-server

3. After the package installation is complete, run mssql-conf setup, follow the prompts to set the SA password and select the version.

# / opt/mssql/bin/mssql-conf setup

4.sqlserver uses port 1433 by default. You can turn off the firewall or open port 1433 for remote access.

Install the SQL Server command line tool

To create a database, you need to connect using a tool that runs Transact-SQL statements on SQL Server. The following steps will install the SQL Server command line tools: sqlcmd and bcp

1. Download the Microsoft Red Hat repository configuration file.

two。 If you installed an earlier version of mssql-tools, remove all old unixODBC packages.

# yum remove unixODBC-utf16 unixODBC-utf16-devel

3. Run the following command to install mssql-tools using the unixODBC developer package.

# yum install-y mssql-tools unixODBC-devel

4. For convenience, add / opt/mssql-tools/bin/ to the PATH environment variable. This allows you to run these tools without specifying the full path. Run the following command to modify the paths for login and interactive / non-login sessions:

# echo 'export PATH= "$PATH:/opt/mssql-tools/bin" > > ~ / .bash_profile#echo' export PATH= "$PATH:/opt/mssql-tools/bin" > > ~ / .bashrc # source ~ / .bashrc

Test local connection

1.sqlcmd-S localhost-U SA-P''

two。 The appearance of 1 > indicates a successful login.

After reading this article on how to install SQLServer2019 in CentOS8, if you think the article is well written, you can share it with more people.

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.