Package Details: mssql-server 16.0.4135.4-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: 30
Popularity: 0.99
First Submitted: 2016-11-17 09:25 (UTC)
Last Updated: 2024-08-12 02:03 (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) (edited on 2024-08-19 04:24 (UTC) by doctorzeus)

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.

If you have a problem compiling libldapV2.4, go and ask on that package page, not here.

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