MSSQL Server 2017 is now out of preview as of 02/10/17, I edited the pkgbuild for myself until it is updated officially.
If anyone wants a copy of this I uploaded it here:
https://1drv.ms/u/s!AjgqKvvQzQ7vgpRe7seO8YU8TCrr6A
New version is 14.0.1000.169-2.
Search Criteria
Package Details: mssql-server 16.0.4135.4-1
Package Actions
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.015904 |
First Submitted: | 2016-11-17 09:25 (UTC) |
Last Updated: | 2024-08-12 02:03 (UTC) |
Dependencies (16)
- gawk (gawk-gitAUR, busybox-coreutilsAUR)
- gdb (gdb-gitAUR, gdb-debug-gitAUR)
- glibc (glibc-gitAUR, glibc-linux4AUR, glibc-eacAUR, glibc-eac-binAUR, glibc-eac-rocoAUR)
- krb5 (krb5-gitAUR)
- libatomic_ops
- libc++ (libc++-msanAUR, libc++-modulesAUR)
- libldap24AUR
- libunwind (libunwind-carbonAUR, libunwind-gitAUR)
- nss (nss-hgAUR)
- numactl (numactl-gitAUR)
- openssl-1.1
- pam (pam-selinuxAUR)
- sed (busybox-coreutilsAUR, sed-gitAUR)
- sssd (sssd-gitAUR, sssd-nosmbAUR)
- debugedit (debugedit-gitAUR) (optional)
- python-pyodbcAUR (optional)
Required by (4)
- mssql-server-fts
- mssql-tools (optional)
- python-pydal-git (optional)
- shlink (optional)
Sources (1)
Latest Comments
« First ‹ Previous 1 .. 6 7 8 9 10 11 12 13 Next › Last »
doctorzeus commented on 2017-10-03 10:08 (UTC) (edited on 2017-10-03 10:15 (UTC) by doctorzeus)
pkral commented on 2017-08-24 12:06 (UTC) (edited on 2017-08-24 12:16 (UTC) by pkral)
@countercraft, I reinstalled mssql-server, mssql-tools, msodbcsql and it works fine. Thank you
countercraft commented on 2017-08-24 10:55 (UTC)
Hi @pkral. I didn't had mssql-tools on my system, so I installed it but I couldn't reproduce the problem. The lib directory seems equals to your system, so unfortunately I have no idea why it doesn't work for you.
$ sqlcmd -S localhost -U sa
Password:
1>
$ ls -l /opt/microsoft/msodbcsql/lib64/
total 18316
lrwxrwxrwx 1 root root 19 nov 6 2016 libcrypto.so.10 -> libcrypto.so.1.0.1e
-rwxr-xr-x 1 root root 2025472 nov 6 2016 libcrypto.so.1.0.1e
-rwxr-xr-x 1 root root 16271992 ago 24 07:46 libmsodbcsql-13.1.so.6.0
lrwxrwxrwx 1 root root 16 nov 6 2016 libssl.so.10 -> libssl.so.1.0.1e
-rwxr-xr-x 1 root root 454024 nov 6 2016 libssl.so.1.0.1e
pkral commented on 2017-08-24 09:19 (UTC)
Hello
I just installed mssql-server and mssql-tools.
After
$ sudo /opt/mssql/bin/mssql-conf setup
...
Setup has completed successfully. SQL Server is now starting.
But after
$ sqlcmd -S localhost -U SA
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Can't open lib 'ODBC Driver 13 for SQL Server' : file not found.
And
$ ls -l /opt/microsoft/msodbcsql/lib64/
total 18316
lrwxrwxrwx 1 root root 19 Nov 6 2016 libcrypto.so.10 -> libcrypto.so.1.0.1e
-rwxr-xr-x 1 root root 2025472 Nov 6 2016 libcrypto.so.1.0.1e
-rwxr-xr-x 1 root root 16271992 Aug 24 08:50 libmsodbcsql-13.1.so.6.0
lrwxrwxrwx 1 root root 16 Nov 6 2016 libssl.so.10 -> libssl.so.1.0.1e
-rwxr-xr-x 1 root root 454024 Nov 6 2016 libssl.so.1.0.1e
Please what I'm missing?
Thank you for your help.
cdvillagra commented on 2017-07-22 03:27 (UTC)
Hey @novaprospekt216, try with 'pacaur':
pacaur -S mssql-server
<deleted-account> commented on 2017-06-26 07:33 (UTC)
Hello,
I am trying to install this using yaourt -S mssql-server but i get the following errors:
tar: ./opt/mssql/lib/system.netfx.sfp: Sólo se escribieron 1024 de 10240 bytes
tar: ./opt/mssql/bin/mssql-conf: No se puede efectuar write: No queda espacio en el dispositivo
tar: ./opt/mssql/bin/paldumper: No se puede efectuar write: No queda espacio en el dispositivo
tar: ./opt/mssql/bin/crash-support-functions.sh: No se puede efectuar write: No queda espacio en el dispositivo
tar: ./opt/mssql/bin/handle-crash.sh: No se puede efectuar write: No queda espacio en el dispositivo
tar: ./opt/mssql/bin/sqlpackage: No se puede efectuar write: No queda espacio en el dispositivo
tar: ./opt/mssql/bin/sqlservr: No se puede efectuar write: No queda espacio en el dispositivo
tar: ./opt/mssql/bin/compress-dump.sh: No se puede efectuar write: No queda espacio en el dispositivo
tar: Se sale con estado de fallo debido a errores anteriores
Meaning there is no space left on the device (but it has over 10GB available), am i doing something wrong? can i free space under /opt or something? (It is a virtualbox machine with 20GB and only 8GB used +-)
Thank you!
SOLVED: I have no swap in the VM and only 2GB of ram. I changed to 4GB ram and problem solved!!
Scimmia commented on 2017-06-01 15:10 (UTC)
rpmextract is completely and totally useless anyway
countercraft commented on 2017-06-01 15:04 (UTC)
@vfsoraki I changed to the Ubuntu version, that's why the current PKGBUILD doesn't depend on rpmextract anymore.
vfsoraki commented on 2017-06-01 14:58 (UTC)
This also needs rpmextract as a dependency. I used PKGBUILD provided by @countercraft.
countercraft commented on 2017-05-10 15:10 (UTC)
https://gist.github.com/anonymous/7f044b51fc4e1c70d191da043481b635
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