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: 30
Popularity: 0.092203
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 9 .. 13 Next › Last »

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.

Nek commented on 2022-12-02 15:20 (UTC)

I get this error:

Validating source files with sha256sums... mssql-server-15.0.4261.1-2.x86_64.rpm ... FAILED

seems that the hosted rpm file has changed and needs rehashing

doctorzeus commented on 2022-11-29 21:31 (UTC) (edited on 2022-11-29 21:35 (UTC) by doctorzeus)

@zwastik and @Roknauta Microsoft sometimes have different directory structures in different azure region instances.. So please tell me the results of:

$ host packages.microsoft.com

Roknauta commented on 2022-11-29 10:36 (UTC)

@zwastik same problem here.

zwastik commented on 2022-11-27 20:00 (UTC) 

==> Making package: msodbcsql 18.1.2.1-1 (Sun 27 Nov 2022 04:59:52 PM -03)                                                                   
==> Checking runtime dependencies...
==> Checking buildtime dependencies...
==> Retrieving sources...
  -> Downloading msodbcsql18-18.1.2.1-1.x86_64.rpm...
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0   162    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
curl: (22) The requested URL returned error: 404
==> ERROR: Failure while downloading https://packages.microsoft.com/rhel/8/prod/Packages/m/msodbcsql18-18.1.2.1-1.x86_64.rpm
    Aborting...

Command 'makepkg' failed to execute.

jorgemota commented on 2022-11-18 23:38 (UTC) (edited on 2022-11-22 20:30 (UTC) by jorgemota)

After I upgraded to this I was unable to start mssql server, Got Setup step is FORCE copying system data file 'C:\templatedata\model_msdblog.ldf' to '/var/opt/mssql/data/model_msdblog.ldf'.

and

Error 5(Access is denied.) occurred while opening file '/var/opt/mssql/data/master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error

cannot run with sudo /opt/mssql/bin/sqlsrv

Reverted to this version: https://aur.archlinux.org/cgit/aur.git/commit/?h=mssql-server&id=26e3f7f344160ba6ee80279b65d18aa9ae7d2ad3

and now can start with systemctl as always.

EDIT updated to latest version, got same error as before on virtualized pc, reverted version got same problem. after upgrade run 

 systemctl disable mssql-server

 chown -R mssql:mssql /opt/mssql 
 chown -R mssql:mssql /var/opt/mssql
 su - mssql
 /opt/mssql/bin/sqlsrvr 
 ##Wait some minutes to wait end upgrades scripts..and press CTRL+C
 exit 
 systemctl enable mssql-server
 systemctl start mssql-server

All starts working again...

mindriddler commented on 2022-11-17 07:45 (UTC)

@doctorzeus I just updated this package and it worked. Then i tried to uninstall and reinstall the package again and everything worked flawless this time.

Thank you for whatever it was you did to resolve the issue i had!

doctorzeus commented on 2022-11-15 21:31 (UTC) (edited on 2022-11-15 21:34 (UTC) by doctorzeus)

@serverach Official repo lists the dependency as openssl >= 1.0.1 but I'm guessing the latest version of openssl that breaks mssql-server hasn't been released on redhat yet..

Technically they should both work (verified this and did not have openssl-1.1 installed when I tried it).. Tested with linking openssl-1.1 libs and they seem to work so will update accordingly as its better to have the newer one..

Also my object dep trace seems to point to the latest version $ ldd /opt/mssql/bin/sqlservr | grep -i ssl OUTPUT: libssl.so.3 => /usr/lib/libssl.so.3 (0x00007f23250a3000)

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