Now Microsoft SQL Server supports on Linux platforms.
I have tested on Redhat, CentOS and Oracle Linux.
Here we will see step by step guide to install SQL server on Linux.
- You need at least 3.25 GB of memory to run SQL Server on Linux.
Install SQL Server
- Login to root user using putty.
su - root
- We will download and install SQL server repositories by using following commands.
# curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo
# curl https://packages.microsoft.com/config/rhel/7/prod.repo
- Verify .repo files under /etc/yum.repos.d/ directory
- To install SQL Server and MSSQL Tools package, run the following commands
# yum install -y mssql-server mssql-tools
- Run the configuration script to accept license terms and set SA password
# cd /opt/mssql/bin/
# sudo ./mssql-config setup
- To verify the mssql-server service is running
# systemctl status mssql-server
- To open tcp-1433 port on system firewall in order to allow external clients to communicate with the database server.
# firewall-cmd --add-port=1433/tcp --permanent
# firewall-cmd --reload
# cd /opt/mssql-tool/bin/
# ./sqlcmd -S srv01 -U SA
Upgrade SQL Server
- To upgrade the mssql-server package on Linux, execute the following command
# yum update mssql-server
Uninstall SQL Server
- To uninstall or remove the mssql-server package on Linux, execute the following command
# yum remove mssql-server
(Remove or delete mssql-server package)
# rm -rf /var/opt/mssql/
(Remove or delete database files)
Congratulations! We are pleased to inform you that your contributions to Microsoft online technical communities have been recognized with the Microsoft Community Contributor badge.
This recognition is reserved for participants who made notable contributions in Microsoft online communities such as MSDN, TechNet and Microsoft Answers. The value of these online resources is greatly enhanced by participants like you who voluntarily contribute your time and energy to improve the online community experience for others.
What does this mean to you?
First, in the next few days, you’ll notice a “MCC” badge appearing next to your name. This will appear automatically and will remain there for the next three months. At this time we will reevaluate your contribution levels to see if the recognition will continue on a quarterly basis.
Additionally, we would like to highlight you on our official badge website. Simply respond to a few questions and we’ll share a little about you with the larger community, including your blog URL, Twitter handle and more. This step is completely optional but will give you some great exposure.
Please note that you will have only one opportunity to complete this information for the next three months.
Questions? Contact us at MCCGA@Microsoft.com.
Once again, congratulations!
The Microsoft Community Contributor Team
Microsoft’s new logo after 25 Years.See on the website: http://www.microsoft.com/
Anti virus Exclusion list for all the microsoft products.
One place on the web where you can find an updated list of ALL the AV exclusions you might want to configure for Windows Server. Feel free to add to the list, it is the wiki way!
Congratulations! We’re pleased to inform you that your contributions to Microsoft online technical communities have been recognized with the Microsoft Community Contributor Award.
The Microsoft Community Contributor Award is reserved for participants who have made notable contributions in Microsoft online community forums such as TechNet, MSDN and Answers. The value of these resources is greatly enhanced by participants like you, who voluntarily contribute your time and energy to improve the online community experience for others.
Becoming a Microsoft Community Contributor Award recipient includes access to important benefits, such as complimentary resources to support you in your commitment to Microsoft online communities. To find out more about the Microsoft Community Contributor Award and to claim your recognition, please visit this site: http://www.microsoftcommunitycontributor.com/
Thank you for your commitment to Microsoft online technical communities and congratulations again!
My MCC Award 2012:
I would like to thank Microsoft and Technet Community members for selecting me for this award.
MCC Current Awardees List.