Tags

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


SQL Server 2017 on LINUX | Installing SQL Server on Ubuntu

In this article we shall discuss about the installation SQL Server 2017 on Ubuntu 16.04.

Note – To configure SQL Server on Ubuntu, run the following commands in a terminal to install the mssql-server package. If you have previously installed a CTP or RC release of SQL Server 2017, you must first remove the old repository before registering one of the GA repositories.

Steps-

1. Import the public repository GPG keys:

	--

	sudo wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

	--

2. Register the Microsoft SQL Server Ubuntu repository.

	--

	sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"

	--

3. Run the following commands to install SQL Server.

	--

	sudo apt-get update
	sudo apt-get install -y mssql-server

	--

4. After the package installation finishes, run mssql-conf setup and follow the prompts to set the SA password and choose your edition.

	--

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

	--

Notes-

1. You can choose editions from Evaluation, Developer, and Express.
2. 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.

5. Once the configuration is done please verify that the service is running or not.

	--

	systemctl status mssql-server

	--

Note – If you plan to connect remotely, you might also need to open the SQL Server TCP port (default 1433) on your firewall.

References-

1 https://docs.microsoft.com/en-us/sql/sql-operations-studio/download
2 https://go.microsoft.com/fwlink/?linkid=875602
3 https://msbiskills.com/2018/01/19/2017-new-data-management-tool-for-sql-server-sql-operations-studio/
4 https://docs.microsoft.com/en-us/sql/sql-operations-studio/download?view=sql-server-2017
5 https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-linux-2017

Other SQL SERVER on Linux related articles

1 https://msbiskills.com/2018/07/11/sql-server-2017-on-linux-faqs-microsoft/
2 https://msbiskills.com/2018/07/17/sql-server-2017-on-linux-how-to-install-sql-operations-studiosos-on-linuxubuntu/

Enjoy.

Thank you for reading.!!!

Pawan Khowal

Pawan is a SQL Server Developer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Performance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com