Package Details: mssql-server 15.0.4188.2-3

Git Clone URL: https://aur.archlinux.org/mssql-server.git (read-only, click to copy)
Package Base: mssql-server
Description: Microsoft SQL Server for Linux
Upstream URL: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-overview?view=sql-server-ver15
Licenses: unknown
Submitter: flash2k2
Maintainer: doctorzeus
Last Packager: doctorzeus
Votes: 24
Popularity: 0.79
First Submitted: 2016-11-17 09:25
Last Updated: 2022-01-02 23:12

Latest Comments

« First ‹ Previous 1 2 3 4 5 6 7 Next › Last »

doctorzeus commented on 2020-01-09 01:40

@gabrielmldantas no luck unfortunately, guessing it's something todo with the upgrade from 2017-2019.. Going to try a fresh install..

Is Microsoft maintaining the 2017 one? If so someone could always start a separate package.

gabrielmldantas commented on 2020-01-08 12:36

@doctorzeus I didn't have this problem but the 2 or 3 last versions of SQL Server had a problem with OpenSSL causing connection failures. That's why I linked the correct OpenSSL libraries directly into the installation directory. Anyway, a new version was released yesterday and it seems to not need the link anymore, so I removed them from the PKGBUILD. You can try to update to see if it works for you.

doctorzeus commented on 2020-01-08 01:39

Don't know if this is package specific (will delete if I find its not) but since the update to 15.0.2000.5 sqlagent refuses to start with:

SQL Server does not accept the connection (error: 11001). Waiting for Sql Server to allow connections. Operation attempted was: Verify Connection On Start.

The agent makes several attempts and finally gives up with the error:

SQLServer Error: 11001, TCP Provider: No such host is known. [SQLSTATE 08001]

Might be to do with the upgrade from 2017 to 2019.

gabrielmldantas commented on 2020-01-06 16:07

@pickfire yes, the config and settings scripts still target Python 2.

pickfire commented on 2020-01-06 01:53

Does it still requires python2?

jiri.one commented on 2019-11-14 12:51

@doctorzeus thanks a lot.

doctorzeus commented on 2019-11-14 12:33

@jiri.one once installed via pacman you run /opt/mssql/bin/mssql-conf and it will set ask you what edition you want to install..

jiri.one commented on 2019-11-14 10:33

I am sorry for this question, but I am not sure about licence of this mssql server. I need free legal Express version, is it possible to use this package or I need another RPM from Microsoft? Thanks for answer.

taliesin commented on 2019-10-27 02:06

When I try to run the setup routine, I get as far as setting a password and then it dies with the error below, so I was wondering if there is anything else I am supposed to be doing:

Confirm the SQL Server system administrator password: 
Configuring SQL Server...

This program has encountered a fatal error and cannot continue running at Sun Oct 27 00:10:46 2019
The following diagnostic information is available:

         Reason: 0x00000002
     Parameters: 0x282e3fdc0
              [0] 0x10010
    Stack Trace:
                 000000006ad36b8e
                 000000006ac63c8d
                 000000006ac0335e
                 000000006ad73ce8
                 0000000282f72f8c
                 0000000282f571b4
                 0000000282f57e09
                 0000000282bc1607
                 0000000282bc1591
                 0000000282bc4108
                 000000028024529d
                 00000002824b3424
                 00000002800c3411
                 00007f28d05ff200
        Process: 4340 - sqlservr
         Thread: 4377 (application thread 0x80)
    Instance Id: 1044b897-126b-4de1-af19-a5832faa29c1
       Crash Id: 9d7e7a06-d5a5-4d58-b156-83f0368a057a
    Build stamp: 8eae22598789388841804a3349ced41f200279564d11ad3e71e184082fd3dd52
   Distribution: Arch Linux
     Processors: 4
   Total Memory: 4005695488 bytes
      Timestamp: Sun Oct 27 00:10:46 2019
     Last errno: 2
Last errno text: No such file or directory

"Arch Linux"
Capturing core dump and information to /var/opt/mssql/log...
Hint: You are currently not seeing messages from other users and the system.
      Users in groups 'adm', 'systemd-journal', 'wheel' can see all messages.
      Pass -q to turn off this notice.
No journal files were opened due to insufficient permissions.
Hint: You are currently not seeing messages from other users and the system.
      Users in groups 'adm', 'systemd-journal', 'wheel' can see all messages.
      Pass -q to turn off this notice.
No journal files were opened due to insufficient permissions.
Sun 27 Oct 2019 12:10:46 AM EDT Capturing program information
Sun 27 Oct 2019 12:10:47 AM EDT Attempting to capture a dump with paldumper
Captured a dump with paldumper
Sun 27 Oct 2019 12:10:47 AM EDT Capturing program binaries
/usr/bin/find: ‘/usr/lib/mysql/plugin/auth_pam_tool_dir’: Permission denied
/usr/bin/find: ‘/usr/share/polkit-1/rules.d’: Permission denied
Sun 27 Oct 2019 12:10:49 AM EDT Compressing the dump files
Core dump and information are being compressed in the background. When
complete, they can be found in the following location:
  /var/opt/mssql/log/core.sqlservr.10_27_2019_00_10_46.4340.tbz2
Initial setup of Microsoft SQL Server failed. Please consult the ERRORLOG
in /var/opt/mssql/log for more information

doctorzeus commented on 2019-03-30 17:52

If you get the following error after updating to 14.0.3076.1+ when running mssql-conf setup (taken from the log file):

TDSSNIClient initialization failed with error 0x2742, status code 0xa. Reason: Unable to initialize the TCP/IP listener. A socket operation encountered a dead network.

This seems to be an issue when ipv6 is disabled via the kernel option. To fix this either enable IPV6 or (even better) disable ipv6 via sysctl instead.