Package Details: mssql-server 16.0.4185.3-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: too
Last Packager: too
Votes: 31
Popularity: 0.60
First Submitted: 2016-11-17 09:25 (UTC)
Last Updated: 2025-03-16 14:29 (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

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

doctorzeus commented on 2023-06-28 18:32 (UTC)

@SL_Pirate There is a post-install message that says you need to run "/opt/mssql/bin/mssql-conf setup" if this is your first time setup.

SL_Pirate commented on 2023-06-27 04:01 (UTC) (edited on 2023-06-27 04:03 (UTC) by SL_Pirate)

I installed the package using yay but when I tried to start the service using systemd, the service failed.

Then I realized the unit file was running the service as the user mssql which did not exist.

So I edited the unit file and removed the line specifying User=mssql, ran sudo systemctl daemon-reload and everything worked fine.

PS:- I'm not sure if this step is necessary but I ran sudo /opt/mssql/bin/sqlservr --accept-eula to accept the EULA

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

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.

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