MS SQL Server 2017 on Linux Has Released

[mlnews]

At MS Ignite, they have officially announced the full release of Microsoft SQL Server 2017 on Linux. This one has been a long time coming and people have really been looking forward to getting their hands on, and testing out, such a major release. In addition to a general Linux installation option, SQL Server 2017 comes ready for Docker, as well.

If you check the download site for MS SQL Server 2017, however, it does not officially support any Linux OS in its current release except for Suse Enterprise Linux, which is currently on 12 SP2. Ubuntu is only supported for the long in the tooth LTS release and RHEL for 7.3 (7.4 is the current patch level.) All SQL Server releases are on LTS platforms.

[DustinB3403]

MS SQL Server 2017 on Linux Has Released

FTFY

[JaredBusch]

Just tried to install this on Fedora 29. No go because OpenSSL is too new. Not particularly surprised.

For the hell of it, I tried to install the 2019 preview and it installed on Fedora 29 with no package errors.

[JaredBusch]

Whoa!

[scottalanmiller]

That's awesome. SO much easier than on Windows!

[JaredBusch]

@scottalanmiller said in MS SQL Server 2017 on Linux Has Released:

That's awesome. SO much easier than on Windows!

Well cannot connect to it yet.

[mlnews]

What does netstat -tulpn say?

[JaredBusch]

But MS has never said it is supposed to work on Fedora. I just thought I would try as sometimes things to do work.

[JaredBusch]

@mlnews said in MS SQL Server 2017 on Linux Has Released:

netstat -tulpn

-bash: netstat: command not found

Let me install net-tools.

[JaredBusch]

Looks like it is listening.

[jbusch@sql ~]$ netstat -tulpn
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      -                   
tcp        0      0 127.0.0.1:1431          0.0.0.0:*               LISTEN      -                   
tcp        0      0 0.0.0.0:1433            0.0.0.0:*               LISTEN      -                   
tcp6       0      0 :::22                   :::*                    LISTEN      -                   
tcp6       0      0 ::1:1431                :::*                    LISTEN      -                   
tcp6       0      0 :::1433                 :::*                    LISTEN      -                   
udp        0      0 0.0.0.0:68              0.0.0.0:*                           -                   
udp        0      0 127.0.0.1:323           0.0.0.0:*                           -                   
udp6       0      0 ::1:323                 :::*                                -                   
[jbusch@sql ~]$ 

[scottalanmiller]

Firewall is definitely open, right?

[JaredBusch]

@scottalanmiller said in MS SQL Server 2017 on Linux Has Released:

Firewall is definitely open, right?

Yes, but SELinux was running, as expected. Just disabled and rebooting.

[flaxking]

My first test of it was on Fedora too, no issues, but that was a bit ago on Fedora 27

[JaredBusch]

@flaxking said in MS SQL Server 2017 on Linux Has Released:

My first test of it was on Fedora too, no issues, but that was a bit ago on Fedora 27

SQL 2017 will not install on Fedora 29 because it said OpenSSL < 1.something was not available.

[JaredBusch]

[jbusch@sql ~]$ sudo sestatus
[sudo] password for jbusch: 
SELinux status:                 disabled
[jbusch@sql ~]$ sudo firewall-cmd --list-ports
1433/tcp
[jbusch@sql ~]$ 

[jbusch@sql ~]$ sudo systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
   Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2018-11-08 17:53:12 CST; 3min 53s ago
     Docs: https://docs.microsoft.com/en-us/sql/linux
 Main PID: 645 (sqlservr)
    Tasks: 113
   Memory: 1.6G
   CGroup: /system.slice/mssql-server.service
           ├─645 /opt/mssql/bin/sqlservr
           └─792 /opt/mssql/bin/sqlservr

Nov 08 17:53:18 sql.jaredbusch.com sqlservr[645]: [62B blob data]
Nov 08 17:53:18 sql.jaredbusch.com sqlservr[645]: [61B blob data]
Nov 08 17:53:18 sql.jaredbusch.com sqlservr[645]: [389B blob data]
Nov 08 17:53:18 sql.jaredbusch.com sqlservr[645]: [96B blob data]
Nov 08 17:53:18 sql.jaredbusch.com sqlservr[645]: [66B blob data]
Nov 08 17:53:18 sql.jaredbusch.com sqlservr[645]: [79B blob data]
Nov 08 17:53:19 sql.jaredbusch.com sqlservr[645]: [96B blob data]
Nov 08 17:53:19 sql.jaredbusch.com sqlservr[645]: [100B blob data]
Nov 08 17:53:19 sql.jaredbusch.com sqlservr[645]: [71B blob data]
Nov 08 17:53:19 sql.jaredbusch.com sqlservr[645]: [124B blob data]

Same error.

[jbusch@sql ~]$ sqlcmd -S localhost -U SA -P 'BNA$upport710'
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2746.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Client unable to establish connection.

I'm not worried about this working, but I was pleasantly surprised.

[JaredBusch]

exact same VM config with CentOS 7 fails because of CentOS uses and reports memory differently.

KVM settings specified 2048 RAM for both the Fedora 29 system and the CentOS 7 system..

[JaredBusch]

Upped it to 3072 RAM and SQL setup completed normally.

[tonyshowoff]

Does it allow odd number processors yet or do I still have to disable one if I don't have an even number?

[Reid Cooper]

@tonyshowoff said in MS SQL Server 2017 on Linux Has Released:

Does it allow odd number processors yet or do I still have to disable one if I don't have an even number?

Even only for licensing, I believe. No change there.