Instalar MSSQL Server Fedora/Centos 7

Fuentes:

• https://docs.microsoft.com/es-es/sql/linux/quickstart-install-connect-red-hat?view=sql-server-2017

• https://computingforgeeks.com/how-to-install-microsoft-sql-2019-on-centos-7-fedora/

Fedora 29

Requiere de la preview 2019

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

Centos 7

su -

sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo

yum install mssql-server mssql-tools unixODBC-devel

Fedora y Centos

/opt/mssql/bin/mssql-conf setup

systemctl start mssql-server
systemctl enabled mssql-server

En mi caso lo instalo en una maquina virtual y solo abro puertos para lan

firewall-cmd --permanent --zone=trusted --add-source=192.168.122.0/24
firewall-cmd --reload

Si no, abrir puerto 1433

firewall-cmd --zone=public --add-port=1433/tcp --permanent
firewall-cmd --reload

# Como usuario
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc

Por ultimo me creo un usuario snicoper con un password fácil,

CREATE LOGIN snicoper WITH PASSWORD = '123456', CHECK_POLICY = OFF;
EXEC sp_addsrvrolemember 'snicoper', 'sysadmin';