How to Install MS SQL on Ubuntu Server 18.04

4

Buy Website Traffic | Increase Website Traffic | SEO Backlinks | Alexa Ranking


Would not you like to have a MS SQL database server mixed with the ability, reliability, and safety of Linux? Now you’ll be able to.

Again in 2016, Microsoft’s relational database, MS SQL, was launched beneath an open supply license. In the event you’re an MS SQL admin and want to have that energy, mixed with the steadiness and safety of Linux, you are in luck. Putting in MS SQL on Ubuntu Server 18.04 is definitely fairly straightforward. After you have it put in, the database server will perform precisely as you’ve got grown accustomed to.

So, let’s set up MS SQL on Ubuntu Server 18.04.

What you want

The one belongings you want are a working Ubuntu 18.04 Server occasion and a consumer with sudo privileges. You’ll be able to run the MS SQL Server with a trial license (or use the Developer or Specific editions), however past that, you will want to buy a license to place the MS SQL Server into manufacturing utilization.

SEE: Server deployment/migration guidelines (Tech Professional Analysis)

Replace/improve

Earlier than we set up MS SQL, the Ubuntu Server must be up to date and upgraded. Know that, ought to the kernel be upgraded, a reboot will likely be required. Due to this, it is best to run the replace/improve course of at a time when a server reboot is feasible.

To run the replace/improve, open a terminal and subject the instructions:

sudo apt-get replace
sudo apt-get improve -y

As soon as the above instructions full, reboot the server (if obligatory), and also you’re prepared to put in.

Set up

The very first thing to do is import the required repository key. From the terminal window, subject the next command:

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

Subsequent, add the repository with the command:

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

Replace apt with the command:

sudo apt-get replace

And, lastly, set up MS SQL with the command:

sudo apt-get set up mssql-server -y

Configure MS SQL server

As soon as the set up completes, you then have to run a setup script and reply the required questions. The script is run with the next command:

sudo /choose/mssql/bin/mssql-conf setup

After answering the entire questions (which incorporates creating an admin password), you’ll then have to restart the MS SQL server with the command:

systemctl restart mssql-server.service

Putting in the command line instruments

You now have a working MS SQL Server. Nonetheless, in an effort to work with it you need to set up the required command line instruments. To do that, subject the next instructions:

sudo apt-get set up curl -y
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.record | sudo tee /and so on/apt/sources.record.d/msprod.record
sudo apt-get replace 
sudo apt-get set up mssql-tools unixodbc-dev
echo 'export PATH="$PATH:/choose/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/choose/mssql-tools/bin"' >> ~/.bashrc
supply ~/.bashrc

The place PASSWORD is the password you arrange through the MS SQL set up.

That is it. You are prepared to start working along with your MS SQL Server on Ubuntu 18.04.

Additionally see

datahero.jpg

Picture: Jack Wallen

Buy Website Traffic | Increase Website Traffic | SEO Backlinks | Alexa Ranking



Source link