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)
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.
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.