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

1 2 3 4 5 6 .. 13 Next › Last »

XcroatoanX commented on 2024-05-15 07:21 (UTC) (edited on 2024-05-15 07:23 (UTC) by XcroatoanX)

Hey, I have installed MSSQL. When I am trying to run the server with systemctl, it gives an error:

× mssql-server.service - Microsoft SQL Server Database Engine
     Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; preset: disabled
)

 Active: failed (Result: exit-code) since Wed 2024-05-15 09:14:59 CEST; 3s ago

   Duration: 2.793s

       Docs: https://docs.microsoft.com/en-us/sql/linux

    Process: 8606 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=18)

   Main PID: 8606 (code=exited, status=18)

        CPU: 3.775s

May 15 09:14:59 archlinux systemd[1]: mssql-server.service: Scheduled restart job, restart counter is at 3.

May 15 09:14:59 archlinux systemd[1]: mssql-server.service: Start request repeated too quickly.

May 15 09:14:59 archlinux systemd[1]: mssql-server.service: Failed with result 'exit-code'.

May 15 09:14:59 archlinux systemd[1]: Failed to start Microsoft SQL Server Database Engine.

May 15 09:14:59 archlinux systemd[1]: mssql-server.service: Consumed 3.775s CPU time, 664.6M memory peak, 0B memory swap peak.

Azad commented on 2024-05-14 10:38 (UTC)

I can't install mssql-server because libldap24 giving this error:

checking for compatible POSIX regex... no configure: error: broken POSIX regex! ==> ERROR: A failure occurred in build(). Aborting...

I tried to download and install libldap24 from aur first but its returning same error

topslick commented on 2024-03-20 19:50 (UTC)

mssql-server 16.0.4115.5-1 runs on linux kernel 6.8.1-arch1-1 big thanks !

lfpuhl commented on 2024-03-19 12:38 (UTC) (edited on 2024-03-19 13:52 (UTC) by lfpuhl)

Current link to download the rpm package https://pmc-geofence.trafficmanager.net/rhel/8/mssql-server-2022/Packages/m/mssql-server-16.0.4115.5-2.x86_64.rpm?geofence=true

SupremeDeity commented on 2024-03-16 14:45 (UTC)

Source seems to be down? For now I am using the actual link from packages.microsoft.com

topslick commented on 2024-01-30 14:57 (UTC)

Problem applies to kernel 6.7.0 , 6.7.1 and 6.7.2 (so far)

jorgemota commented on 2024-01-30 14:51 (UTC) (edited on 2024-02-01 05:39 (UTC) by jorgemota)

thanks @BenekDlugonogi for the info I will try a kernel downgrade

edit: Tried downgrade but after a few minutes got same error on 6.6.10.arch1-1

synthead commented on 2024-01-24 17:49 (UTC)

Upstream issue, identified by mssql-docker: https://github.com/microsoft/mssql-docker/issues/868

Like others mentioned, this is due to running Linux 6.7.

synthead commented on 2024-01-24 17:44 (UTC)

mssql-server does not start, and crashes with this error message:

This program has encountered a fatal error and cannot continue running at Wed Jan 24 09:29:05 2024
The following diagnostic information is available:

         Reason: 0x00000001
         Signal: SIGABRT - Aborted (6)
          Stack:
                 IP               Function
                 ---------------- --------------------------------------
                 00006173a9272071 std::__1::bad_function_call::~bad_function_call()+0x4e361
                 00006173a9271a36 std::__1::bad_function_call::~bad_function_call()+0x4dd26
                 00006173a9270fbf std::__1::bad_function_call::~bad_function_call()+0x4d2af
                 000073fcde65c710 __sigaction+0x50
                 000073fcde6ac83c pthread_key_delete+0x14c
                 000073fcde65c668 raise+0x18
                 000073fcde6444b8 abort+0xd7
                 00006173a91f9926 malloc_usable_size+0x95a6
                 00006173a929e4e4 std::__1::basic_stringbuf<char, std::__1::char_traits<char>, std::__1::allocator<char>>::str() const+0x28fa4
                 00006173a92cf2d8 std::__1::basic_stringbuf<char, std::__1::char_traits<char>, std::__1::allocator<char>>::str() const+0x59d98
                 00006173a92cf0ba std::__1::basic_stringbuf<char, std::__1::char_traits<char>, std::__1::allocator<char>>::str() const+0x59b7a
                 00006173a91ffd9a malloc_usable_size+0xfa1a
                 00006173a91ffa10 malloc_usable_size+0xf690
        Process: 167245 - sqlservr
         Thread: 167351 (application thread 0x194)
    Instance Id: <censored>
       Crash Id: b16f2324-7f6c-4c4a-b75e-f03b043c6eb2
    Build stamp: a0f40cc5a7930f5bc46977fe25bd42d8ef3df957ea121387d5d0d11efb8b8bd2
   Distribution: Arch Linux
     Processors: 8
   Total Memory: 33417138176 bytes
      Timestamp: Wed Jan 24 09:29:05 2024
     Last errno: 2
Last errno text: No such file or directory