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.74
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 2 3 4 5 6 7 8 .. 13 Next › Last »

doctorzeus commented on 2023-05-16 10:06 (UTC)

@0BAD-C0DE

https://aur.archlinux.org/packages/mssql-tools

0BAD-C0DE commented on 2023-05-16 09:48 (UTC)

Is this the package to get the mssql terminal client?

rubberduck commented on 2023-05-04 17:09 (UTC) (edited on 2023-05-04 17:11 (UTC) by rubberduck)

If you're looking to get Sql Server 2022 (v16), this patch worked for me.

diff --git a/PKGBUILD b/PKGBUILD
index 8fca897..61005e2 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -2,13 +2,13 @@
# Contributor: Gabriel Morrison Lima Dantas <gabrielmldantas@gmail.com>
# Contributor: Aleksey Kamenskikh <aleksey.kamenskikh@gmail.com>
pkgname=mssql-server
-pkgver=15.0.4298.1
-_remRevision=1
+pkgver=16.0.4025.1
+_remRevision=13
_prodver=${pkgver}-${_remRevision}
pkgrel=1
pkgdesc="Microsoft SQL Server for Linux"
arch=('x86_64')
-url="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-overview?view=sql-server-ver15"
+url="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-overview?view=sql-server-ver16"
license=('unknown')
depends=(
    'libatomic_ops'
@@ -31,9 +31,10 @@ optdepends=(
);

#This is a local azure instance that resolves as an alias of "packages.microsoft.com/rhel/7/mssql-server-2019" as some regions have different dir structures
-source=("http://csd-apt-sea-d-4.southeastasia.cloudapp.azure.com/rhel/7/mssql-server-2019/${pkgname}-${_prodver}.x86_64.rpm")
+# source=("http://csd-apt-sea-d-4.southeastasia.cloudapp.azure.com/rhel/7/mssql-server-2019/${pkgname}-${_prodver}.x86_64.rpm")
+source=("http://packages.microsoft.com/rhel/8/mssql-server-2022/Packages/m/${pkgname}-${_prodver}.${arch}.rpm")

-sha256sums=('d5e6c61b59c86ee9003956d5d8cba3de7d59b456fa1a60deac6aa15fc1e1d922')
+sha256sums=('4c436f10975a46705dfc5eb5f968b49045dc5e8905e95cc8b4f8c2a3375f14e5')

install=$pkgname.install

taliesin commented on 2023-02-28 20:38 (UTC)

Just wondering, do you plan to upgrade this package to SQL Server 2022 (16.x) in the near future?

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-overview?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

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

@rybardev

Only the binaries so no source building, however the issue has always occured when you try to actually run the thing.. Microsoft lists libldap V2.4 as a dep in the red hat release so have to keep the legacy version until this changes..

ryanbarillos commented on 2023-01-22 04:22 (UTC)

Did a git clone of the package, and I find that the problem with the libldap24 package is on this line:

'libldap<=2.4.59'

the PKGBUILD demands and older version of the package, not the latest v2.6.3-2 found in the official Arch repository.

However, changing that line into this new line allows for the package to completely build and install:

'libldap'

Which will mean any version of libldap will allows mssql-server from compiling and installing without a necessary version check.

doctorzeus commented on 2023-01-18 07:30 (UTC)

@topslick Can you go and mention this on the libldap24 package page? I don't maintain that and your query is specific to that..

topslick commented on 2022-12-26 21:00 (UTC)

DB5 recently has been upgraded to 5.3. This upgrade breaks dependency libldap24, which can't be build any more. Build of libldap24 breaks with :

checking for db.h... yes checking for Berkeley DB major version in db.h... 6 checking for Berkeley DB minor version in db.h... 2 checking if Berkeley DB version supported by BDB/HDB backends... no configure: error: BerkeleyDB version incompatible with BDB/HDB backends ==> ERROR: A failure occurred in build(). Aborting... -> error making: libldap24

Installing db5.1 from aur, did not help as it's still the db5.3 that is seen by the build. Thx for helping out.

doctorzeus commented on 2022-12-04 23:03 (UTC)

For anyone who has been having problems with the package url not resolving, I have updated the package source to the direct alias of "packages.microsoft.com" to my region's azure instance.

This should solve the issue with different users regions having different directory structures until a more ideal solution comes to light.

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