Rozetka UA

Install Microsoft SQL Server On Ubuntu 17.04

Install Microsoft SQL Server On Ubuntu 17.04

 

4. Install SQL Server
we have to run ‘apt-get update’ in order to sync the package index files with the new source that we’ve just added. Import the public repository GPG keys
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
5. Register the Microsoft SQL Server Ubuntu repository:
curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql-server.list
 6. Run the following commands to install SQL Server:
sudo apt-get update
sudo apt-get install -y mssql-server

7. When the package installation will be finished, we have to run ‘mssql-conf’ setup and ensure we agree to accept the license term. Then Enter the SQL Server system administrator password. Make sure to specify a strong password for the SA account (Minimum length 8 characters, including uppercase and lowercase letters, base 10 digits and/or non-alphanumeric symbols).

sudo /opt/mssql/bin/mssql-conf setup

8. Once the configuration is done, verify that the service is running:

systemctl status mssql-server

9. Connect to the server from Linux we need to install the ‘mssql-tools’ package, which comes from a different repository than the one that we just set up. It can be found here:

sudo apt-get update
10. Re-run the installation command, this will upgrade the specific mssql-server package:
sudo apt-get install mssql-server .Now need install sql server tools.

11. Install the mssql-tools on Ubuntu.First Step Import the public repository GPG keys

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –
12 Register the Microsoft Ubuntu repository.
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
13 Update the sources list and run the installation command with the unixODBC developer package.
sudo apt-get update 
sudo apt-get install mssql-tools unixodbc-dev

System will ask you to do continue ? Press YES

Добавить комментарий

Ваш e-mail не будет опубликован. Обязательные поля помечены *

Pratik UaPratik UaPratik Ua