Package Details: mssql-server 16.0.4115.5-1

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://learn.microsoft.com/en-us/sql/linux/sql-server-linux-overview?view=sql-server-ver16
Licenses: unknown
Submitter: flash2k2
Maintainer: doctorzeus
Last Packager: doctorzeus
Votes: 29
Popularity: 0.75
First Submitted: 2016-11-17 09:25 (UTC)
Last Updated: 2024-03-19 19:04 (UTC)

Pinned Comments

doctorzeus commented on 2023-05-16 10:15 (UTC) (edited on 2023-06-17 03:56 (UTC) by doctorzeus)

This current package is MSSQLServer2022.

For anyone who needs to set the compatibility level of a db to migrate to an older version, see this article:

https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16

doctorzeus commented on 2023-02-22 22:23 (UTC)

NOTES ON libldap 2.4:

Yes there is a newer version in the official repos but the binaries do not run without this version which is listed in the dependencies by Microsoft.

You can get libldap V2.4 here from this AUR package:

https://aur.archlinux.org/packages/libldap24

Latest Comments

« First ‹ Previous 1 .. 5 6 7 8 9 10 11 12 13 Next › Last »

doctorzeus commented on 2019-11-14 12:33 (UTC)

@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 (UTC)

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 (UTC) (edited on 2019-10-27 04:15 (UTC) by taliesin)

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 (UTC) (edited on 2019-04-11 00:27 (UTC) by doctorzeus)

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.

countercraft commented on 2018-03-05 11:39 (UTC) (edited on 2018-03-05 11:39 (UTC) by countercraft)

@doctorzeus Yes, it's bundled now: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-sql-agent

doctorzeus commented on 2018-03-03 02:52 (UTC)

Assuming Microsoft bundled the mssql-server-agent into the mssql-server package?

/opt/mssql/lib/sqlagent.sfp seems to now be included?

countercraft commented on 2018-01-31 14:34 (UTC)

@1k2ka it was removed on SQL Server 2017 RC1: https://stackoverflow.com/a/45355746

1k2ka commented on 2018-01-30 16:08 (UTC)

Does anyone know what happend to "/opt/mssql/bin/sqlpackage"? Has it been replaced by something else or has it been removed?

doctorzeus commented on 2017-10-03 10:08 (UTC) (edited on 2017-10-03 10:15 (UTC) by doctorzeus)

MSSQL Server 2017 is now out of preview as of 02/10/17, I edited the pkgbuild for myself until it is updated officially. If anyone wants a copy of this I uploaded it here: https://1drv.ms/u/s!AjgqKvvQzQ7vgpRe7seO8YU8TCrr6A New version is 14.0.1000.169-2.

pkral commented on 2017-08-24 12:06 (UTC) (edited on 2017-08-24 12:16 (UTC) by pkral)

@countercraft, I reinstalled mssql-server, mssql-tools, msodbcsql and it works fine. Thank you

« First ‹ Previous 1 .. 5 6 7 8 9 10 11 12 13 Next › Last »