Wish you all a very happy new year folks! Been a while since I posted something, so here I am 🙂 I would like to begin my blogging in year 2020 with Linux. Long ago, I wrote an article on how to setup a VM with CentOS and install SQL 2017 on top of it. I am not going to walk through those steps again., Instead let’s see if the setup experience is any different from SQL 2017 on RHEL.
Before begin installing, Let me examine repos on my linux machine. you can do that by navigating to /etc/yum.repos.d folder.
Well, this is a brand new installation. That explains all the repositories I have on my machine! Now, It’s time to download SQL Server repo from microsoft.
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo
Once this part is done, it’s time for actual installation.
sudo yum install -y mssql-server
Alright, let’s perform the configuration portion(EULA,Edition,sa pwd) as instructed by setup program.
sudo /opt/mssql/bin/mssql-conf setup
Oops! My configuration failed. you can clearly see the reason why my installation failed. I was way too conservative in terms of granting resources to my VM. Once I bumped up my RAM to 4 GB, all went well.
Check status using either ps-ef | grep mssql-server or systemctl command as shown below.
Now it is time to install client tools on the server. Microsoft has provided a separate repo for client tools which we need to download similar to what we did in step 1.
sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/8/prod.repo
Note: Check RHEL version (7 or 8) and download appropriate repos.
Don’t forget to add sqlcmd and bcp tools to path to avoid providing literal path every time we need to access sqlcmd. I hope microsoft will take care of this as part of post installation in future releases instead of manual intervention. ( Symbolic links may be??)
Testing what we have done so far…..
That’s it for this blog post folks! As you can see the installation experience hasn’t been changed much from the last version of SQL on Linux!
Note: This is online setup experience, assuming your Linux machine can talk to internet. Microsoft did a great job on documenting online and offline installation methods. I would definitely recommend anyone to go through the documentation for more details.