MS SQL Server 2017 on Linux Has Released

[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.