Windows way to Digital Learning……

Archive for the ‘Uncategorized’ Category

How to Install Microsoft SQL Server on Linux

sql-on-linux

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.

Supported platforms

Platform

Supported version(s)

Get

Red Hat Enterprise Linux

7.3

Get RHEL 7.3

SUSE Linux Enterprise Server

v12 SP2

Get SLES v12 SP2

Ubuntu

16.04 and 16.10

Get Ubuntu 16.04

Docker Engine

1.8+

Get Docker

Prerequisites

  • 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
> /etc/yum.repos.d/mssql-server.repo

# curl https://packages.microsoft.com/config/rhel/7/prod.repo
> /etc/yum.repos.d/msprod.repo

 

sql-on-linux_curl

  • Verify .repo files under /etc/yum.repos.d/ directory

sql-on-linux_repos

  • To install SQL Server and MSSQL Tools package, run the following commands
# yum install -y mssql-server mssql-tools

sql-on-linux_1

sql-on-linux_2

sql-on-linux_3

  • Run the configuration script to accept license terms and set SA password
# cd /opt/mssql/bin/
# sudo ./mssql-config setup

 

sql-on-linux_4

  • To verify the mssql-server service is running
# systemctl status mssql-server

sql-on-linux_5

  • 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

 

sql-on-linux_6

  • Testing SQL Server
# 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)
Advertisements

Your online community contributions have been recognized by Microsoft

Dear Mohammed,

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

Windows Anti Virus Exclusion List Wiki

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!

http://social.technet.microsoft.com/wiki/contents/articles/953.aspx

 

Microsoft Community Contributor Award 2012

Dear Mohammed,

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.

 

 

Tag Cloud