In this video we’ll take a look at how you can set up a working MSSQL Server on a Linux machine, to be more specific on a CentOS 7 server.

Step 1: get the repo
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-preview.repo

Step 2: Update yum cache
sudo yum makecache

Step 3: Install the SQL Server:
sudo yum install -y mssql-server

Step 4: Run the setup:
sudo /opt/mssql/bin/mssql-conf setup
– Then follow the guide on screen

Step 5: Install SQL Server cmd tools
sudo yum -y install mssql-tools unixODBC-devel

Step 6: Start and enable the server so it runs as a service.
systemctl start mssql-server
systemctl enable mssql-server

Step 7: Add MSSQL paths to the $Path variable
echo ‘export PATH=$PATH:/opt/mssql/bin:/opt/mssql-tools/bin’ | sudo tee /etc/profile.d/mssql.sh

Step 8: Source the file
source /etc/profile.d/mssql.sh

Thank you for watching! 🙂

You can find my twitch here:
http://www.twitch.tv/RMDetho
Feel free to follow me on Twitter as well!
https://twitter.com/Dethorhyne