| 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.30 |
| First Submitted: | 2016-11-17 09:25 (UTC) |
| Last Updated: | 2024-08-12 02:03 (UTC) |
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
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:
Is this the package to get the mssql terminal client?
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
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
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:
@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..
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.
@topslick Can you go and mention this on the libldap24 package page? I don't maintain that and your query is specific to that..
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