Arch Linux User Repository

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

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

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.

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.

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

@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

@zwastik same problem here.

==> 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.

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...

@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!

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

openssl 1.0 is not correct. Please revert to openssl 1.1. It keeps working because you didn't remove openssl 1.1. Remove the non depends openssl to show the requirement.

ldd /opt/mssql/bin/sqlservr | grep -i ssl
    libssl.so.1.1 => /usr/lib/libssl.so.1.1 (0x00007ff49b61c000)