Installation issues MSSQL 2019 in SLES 15 SP04

Question

Hi Experts

I tried first time to install MSSQL Server 2019 to a new installed VM running SLES 15 SP4.

While installation of SLES 15 the following packages were selected:

• Basesystem Module
• Desktop Application Module
• Development Tools Module
• SUSE Linux Enterprise Workstation Extension 15
• Server Application Module

Then I started the installation procedure of MSSQL Server 2019 as described under https://learn.microsoft.com/de-de/sql/linux/quickstart-install-connect-suse?view=sql-server-linux-ver15

Everything is working fine until step 3 (install SQL Server) with the following command

• sudo zypper install -y mssql-server

I receive a warning message that

Retrieving repository 'packages-microsoft-com-mssql-server-2019' metadata .............................................................................................[done]  
Building repository 'packages-microsoft-com-mssql-server-2019' cache ..................................................................................................[done]  
Loading repository data...  
Reading installed packages...  
Resolving package dependencies...  
  
Problem: nothing provides 'gdb' needed by the to be installed mssql-server-15.0.4249.2-1.x86_64  
 Solution 1: do not install mssql-server-15.0.4249.2-1.x86_64  
 Solution 2: break mssql-server-15.0.4249.2-1.x86_64 by ignoring some of its dependencies  
  
Choose from above solutions by number or cancel [1/2/c/d/?] (c): c  

the package "gdb" is easy installed with the following command:

• sudo zypper install -y gdb

But when repeating the installation I receive the next warning:

Retrieving repository 'packages-microsoft-com-mssql-server-2019' metadata .............................................................................................[done]  
Building repository 'packages-microsoft-com-mssql-server-2019' cache ..................................................................................................[done]  
Loading repository data...  
Reading installed packages...  
Resolving package dependencies...  
  
Problem: nothing provides 'openldap2' needed by the to be installed mssql-server-15.0.4249.2-1.x86_64  
 Solution 1: do not install mssql-server-15.0.4249.2-1.x86_64  
 Solution 2: break mssql-server-15.0.4249.2-1.x86_64 by ignoring some of its dependencies  
  
Choose from above solutions by number or cancel [1/2/c/d/?] (c): c  

Now openldap2 is missing and I didn't find a SUSE repo which includes the package for manual installation. So I decided to ignore the dependencie and continued the installation with option 2. It seems the installation was done without additional errors and also MSSQL 2019 is running properly at the moment.

Are you aware about such installation issue or is something wrong with my SLES 15 installation. Related to many other documentations all of my steps were executed properly and it seems nobody else has such issues.

Also in official install docu nothing about these dependencies is described.

Answer 1

Hi @March_MZ ,

Hope everything goes well.I put that link mainly because I want you to find the installation log so that you can find the reason why the installation failed. This is also the main method we use to troubleshoot installation failures.
As for versioning issues, you can give your feedback here, which can be seen by the Microsoft product team. Your issue may be resolved in the next update. For a better user experience, the Microsoft team refers to the posts in this link every time they make an upgrade to their products.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it.

Answer 2

Hi @March_MZ ,

Welcome to Microsoft Q&A!
Since SLES 15 SP04 is not a Microsoft product, you can refer to this article, which may give you more information.
https://documentation.suse.com/sbp/all/html/TRD-sql-server-getting-started/index.html
For troubleshooting, the logs and crash dumps are written to /var/opt/mssql/log by default. You can see if there is any specific error message in it, and if so, you can post it.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Comment doesn't work so see my comment as an answer:

Hi @Seeya Xi-MSFT

Thanks for the fast response. I am fully aware that SLES is not a product from MS. But when a product is incompatible or has installation issue the first contact person for me is the publisher of the product I want to install.

The link you've provided is about installation of SQL 2019 into SLES12 - not SLES15. I tried as well to use SLES12 for MSSQL 2019 installation which is also not working properly in SLES12 SP5 - but this is another story. Only installation of MSSQL 2017 is working fine in SLES12.

I am aware about the official installation documentations from SUSE and Microsoft. Both are similar and both are not working too ;)

I've found the root cause why I run into the mentioned installation issues. It looks like SUSE discontinues OpenLDAP from SLES15 SP2 and higher because it's deprecated and unsupported in codestream 15:
https://documentation.suse.com/de-de/sles/15-GA/html/SLES-all/cha-security-ldap.html

It was replaced with new 389 Directory Server deployments. Now the problem is that the old install procedure of MSSQL doesn't work with SLES15 SP2 or higher and there is no workaround or at least nobody is caring about. I was really happy to be able to use MSSQL for Linux Servers. But in my opinion it makes no sense if only old Linux versions are supported by MS. And I don't believe that SUSE will adjust Microsofts installation scripts in that case.

In addition MS doesn't restrict MSSQL 2019 to any SP of SLES15. If MSSQL is not compatible with SLES15 SP2 or higher it would be really very appreciated to mention it the documentation.