How to install MS SQL Server 2017 on CentOS 7

There are many instructions and how-to’s regarding installing MS SQL Server 2017 on CentOS 7 but here are my notes about it:

  1. You should plan how to setup your CentOS 7 system because by default MS SQL Server hold his files in those directories:
    1. SQL Server 2017 file location after install
    2. database and others
    3. Of course this directories can be changed after install, but does anyone change directories for MySQL/PostgreSQL ?
  2. Read carefully documentation provided by Microsoft ®, especially this:
    https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-red-hat?view=sql-server-2017
    https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-performance-best-practices?view=sql-server-2017
    https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017
  3. Check if your software will work with MS SQL Server running on Linux. Some software will work but you will probably have no support if you run it that way.

Here is how I have setup my CentOS 7 to work with MS SQL Server only

  1. I have created Virtual Machine which has:
    2 x CPU’s
    8 GB of RAM
    100 GB of space
    1 x NIC
  2. Disk partitioning:
    /boot – 1024 MB
    / – 30 GB
    /var – 60 GB
    /tmp – 5 GB
    /var/log – 5 GB
    /swap – 8192 MB
  3. CentOS 7 setup
    1. Update system
    2. Enable EPEL repo (not necessery, but I like to have it)
    3. Download MS SQL Server 2017 repo
    4. Install
    5. Setup
  4. Enabling TCP port on firewall
  5. Connecting from SQL Management Studio
    1. Logon screen
    2. After logon screen

I think this is all … for now 😉 I will try to write something more after I will test it in production.

Leave a Reply

Your email address will not be published. Required fields are marked *