Wednesday, February 16, 2022

How To Deploy Microsoft SQL Server 2019 on Rocky Linux 8.5

 in This Tutorial you will Learn " How To Install Microsoft SQL Server 2019 on Rocky Linux 8.5"
Microsoft SQL Server is a relational database management system developed by Microsoft.
_________________________________________________________________________________________
Server - Os:  Rocky Linux 8.5  64Bit      | IP -192.168.1.60        |Hostname - server.yourdomain.com
_________________________________________________________________________________________
cat /etc/system-release ; hostname ; hostname -I ; dnf groupinstall "Development Tools" -y

curl https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo -o /etc/yum.repos.d/mssql-server-2019.repo
curl https://packages.microsoft.com/config/rhel/8/prod.repo -o /etc/yum.repos.d/msprod.repo
dnf -y install mssql-server mssql-tools unixODBC-devel
rpm -qi mssql-server

sudo /opt/mssql/bin/mssql-conf setup    [ *K;I~21i0>H]|04 ]
systemctl status mssql-server

echo 'export PATH=$PATH:/opt/mssql/bin:/opt/mssql-tools/bin' | sudo tee /etc/profile.d/mssql.sh
source /etc/profile.d/mssql.sh
firewall-cmd --add-port=1433/tcp --permanent ; firewall-cmd --reload
sqlcmd -S localhost -U SA
select name from sysusers;
go
_________________________________________________________________________________________

No comments:

Post a Comment