Installing mssql on centos 7

2019-07-09 - How to install mssql on centos 7
Tags: Centos Rhel Toolbox


I had to do this in order to help a friend, I do not think I would ever willingly put mssql in production unless I went crazy.


Here is how to setup mssql on a fresh centos 7

vi /etc/sysconfig/network-scripts/ifcfg-eth0
vi /etc/resolv.conf
curl -o /etc/yum.repos.d/mssql-server.repo
curl -o /etc/yum.repos.d/mssql-prod.repo
yum update
yum install -y mssql-server mssql-tools
yum install -y sudo
localectl set-locale LANG=en_US.utf8
echo "export LANG=en_US.UTF-8" >> /etc/profile.d/
echo "export LANGUAGE=en_US.UTF-8" >> /etc/profile.d/
yum install -y openssh-server
systemctl enable sshd
systemctl start sshd
/opt/mssql/bin/mssql-conf setup
rm -f /etc/localtime
ln -s /usr/share/zoneinfo/Europe/Paris /etc/localtime
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -p