Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: MS SQL Server on v15

  1. #1

    Default MS SQL Server on v15

    Since we lost support for Leap 42.3, I need to migrate to v15. However, I run many databases on Leap 42.3.
    My main concern is that I need to install MS SQL Server 2017 on OpenSuse v15 or 15.1.

    I cannot locate any definite answers anywhere online so far regarding MS SQL Server and OpenSuse 15 or SLES 15.

    Does anyone know?

    I love to stay with OpenSuse--but I may have to migrate to Fedora 30 where MS SQL Server is supported (i.e. known to be installed).

    Thank you,
    ArDrakho

  2. #2
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,254
    Blog Entries
    2

    Default Re: MS SQL Server on v15

    Quote Originally Posted by ArDrakho View Post
    Since we lost support for Leap 42.3, I need to migrate to v15. However, I run many databases on Leap 42.3.
    My main concern is that I need to install MS SQL Server 2017 on OpenSuse v15 or 15.1.

    I cannot locate any definite answers anywhere online so far regarding MS SQL Server and OpenSuse 15 or SLES 15.

    Does anyone know?

    I love to stay with OpenSuse--but I may have to migrate to Fedora 30 where MS SQL Server is supported (i.e. known to be installed).

    Thank you,
    ArDrakho
    What version of MSSQL are you trying to run, Express, Standard, Enterprise?

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  3. #3
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,254
    Blog Entries
    2

    Default Re: MS SQL Server on v15

    Without attempting to install,
    I found the following...
    The following are links for MSSQL 2017, there are also previews for MSSQL 2019 (If you're migrating, you may want to do this upgrade as well)

    Microsoft Quickstart on SLES 12
    This is the basic instructions, but recommend the SLES 15 repo which is next
    BTW - I suspect the addrepo command is incorrect, should point to the directory that contains the .repo file and should not include that file name... But on the other hand, I'm surprised there are several .repo files in the directory
    https://docs.microsoft.com/en-us/sql...ql-server-2017

    SLES 15 repo (likely works for openSUSE 15.0/15.1 as well but needs to be tried)
    There is only one .repo file in the directory, unlike the SLES 12 repo
    https://packages.microsoft.com/config/sles/15/

    I assume that you've already had experience administering MSSQL on Linux, the following describes unavailable features on Linux...
    Bottom line, supports only single instance and not clustered deployments, DTC not supported, no GUI management tool (at least not Microsoft), lack of several fault tolerant features
    https://docs.microsoft.com/en-us/sql...7#known-issues

    There is also a dockerized MSSQL which can be deployed on any Linux (or Windows containers)

    Any issues, just post.

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  4. #4

    Default Re: MS SQL Server on v15

    Quote Originally Posted by tsu2 View Post
    What version of MSSQL are you trying to run, Express, Standard, Enterprise?

    TSU
    Developer Edition (i.e. Enterprise version)

  5. #5

    Default Re: MS SQL Server on v15

    Quote Originally Posted by tsu2 View Post
    Without attempting to install,
    I found the following...
    The following are links for MSSQL 2017, there are also previews for MSSQL 2019 (If you're migrating, you may want to do this upgrade as well)

    Microsoft Quickstart on SLES 12
    This is the basic instructions, but recommend the SLES 15 repo which is next
    BTW - I suspect the addrepo command is incorrect, should point to the directory that contains the .repo file and should not include that file name... But on the other hand, I'm surprised there are several .repo files in the directory
    https://docs.microsoft.com/en-us/sql...ql-server-2017

    SLES 15 repo (likely works for openSUSE 15.0/15.1 as well but needs to be tried)
    There is only one .repo file in the directory, unlike the SLES 12 repo
    https://packages.microsoft.com/config/sles/15/

    I assume that you've already had experience administering MSSQL on Linux, the following describes unavailable features on Linux...
    Bottom line, supports only single instance and not clustered deployments, DTC not supported, no GUI management tool (at least not Microsoft), lack of several fault tolerant features
    https://docs.microsoft.com/en-us/sql...7#known-issues

    There is also a dockerized MSSQL which can be deployed on any Linux (or Windows containers)

    Any issues, just post.

    TSU
    Yes, you found all that I located. Also, I also located some recent articles and other forum posts--they seem to talk around the subject.

    I also reviewed the contents in the SLES15 repo directory--which seems to be missing the actual files for MS SQL Server 2017 or the preview 2019 as compared to SLES12 repo directory.

    Just wish the Suse or OpenSuse teams would publicly publish that we can or cannot (at least a possible work-around).

    Thanks!!

  6. #6
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    2,545

    Smile Re: MS SQL Server on v15

    Quote Originally Posted by ArDrakho View Post
    Just wish the Suse or OpenSuse teams would publicly publish that we can or cannot (at least a possible work-around).
    Looking at the SQL Server 2019 preview published by the Redmond folks, it seems that only SLES12 SP2 is recognised.
    Looking at SUSE's Lifecycle notices, SLES12 has general support up to the 31st of October 2024 or, SLES12 SP4 has general support up to 6 months after SLES12 SP5 release.

    • SLES12 SP2 has general support up to the 31st of March 2018 and Long Term Support until the 31st of March 2021.
    • Hopefully the Redmond folks will offer a SQL Server version suitable for SLES15 before October 2024 …


    We have absolutely no control over how the folks in the woods around Seattle tick …

  7. #7
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,254
    Blog Entries
    2

    Default Re: MS SQL Server on v15

    I've spent as much time as I can on this...
    There are a few problems with what is available,
    First it should be recognized that the repo and its contents, plus the instructions are all Microsoft and likely setup and written by someone unfamiliar with openSUSE.. only by someone who read some documentation but not a regular User.

    First major issue is that a gpg cert somewhere in the authentication chain is self-signed which is breaking simple, normal and direct commands to add and refresh the repo. Whatever is happening, I cannot find a zypper configuration that works, and may be the reason why the documentation describes installing a repo configuration which in turn installs the repo instead of installing the repo directly. If this is why the convoluted repo configuration, such are the devices of the uninformed.

    The other major issue is that the repodata metadata is faulty in some way. If you look at the repo.xml, it's big... that's a lot of stuff to have to verify is correct.

    The remaining method which will probably work but I'm not going to do for at least the next few days is to replicate the repos to a local location and set up your own repository with its own level of security. Since I don't expect the packages to change, it's possibly an acceptable risk.

    Bottom line though, the Microsoft repos should be fixed by Microsoft themselves.

    If you want to copy the actual MSSQL repos(bypassing the configuration repos in the documentation), they're here...
    They're all here... MSSQL for SLES 11, SLES 12, SLES15 and of course SLES15 is supposed to be similar to openSUSE 15
    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  8. #8
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,254
    Blog Entries
    2

    Default Re: MS SQL Server on v15

    For example,
    The following is the URI for MSSQL 2017 on SLES 15, which is what I recommend for now for openSUSE 15/15.1

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  9. #9

    Default Re: MS SQL Server on v15

    Quote Originally Posted by dcurtisfra View Post
    Looking at the SQL Server 2019 preview published by the Redmond folks, it seems that only SLES12 SP2 is recognised.
    Looking at SUSE's Lifecycle notices, SLES12 has general support up to the 31st of October 2024 or, SLES12 SP4 has general support up to 6 months after SLES12 SP5 release.

    • SLES12 SP2 has general support up to the 31st of March 2018 and Long Term Support until the 31st of March 2021.
    • Hopefully the Redmond folks will offer a SQL Server version suitable for SLES15 before October 2024 …


    We have absolutely no control over how the folks in the woods around Seattle tick …
    I saw that too. I downloaded the SLES 12 with the 1-Year Developer License--hoping I do not have to use this option. Though, I could study and easily get the SCA this way.

    I hope Microsoft get Suse 15 certified soon!

    Thank you!

  10. #10

    Default Re: MS SQL Server on v15

    Quote Originally Posted by tsu2 View Post
    I've spent as much time as I can on this...
    There are a few problems with what is available,
    First it should be recognized that the repo and its contents, plus the instructions are all Microsoft and likely setup and written by someone unfamiliar with openSUSE.. only by someone who read some documentation but not a regular User.

    First major issue is that a gpg cert somewhere in the authentication chain is self-signed which is breaking simple, normal and direct commands to add and refresh the repo. Whatever is happening, I cannot find a zypper configuration that works, and may be the reason why the documentation describes installing a repo configuration which in turn installs the repo instead of installing the repo directly. If this is why the convoluted repo configuration, such are the devices of the uninformed.

    The other major issue is that the repodata metadata is faulty in some way. If you look at the repo.xml, it's big... that's a lot of stuff to have to verify is correct.

    The remaining method which will probably work but I'm not going to do for at least the next few days is to replicate the repos to a local location and set up your own repository with its own level of security. Since I don't expect the packages to change, it's possibly an acceptable risk.

    Bottom line though, the Microsoft repos should be fixed by Microsoft themselves.

    If you want to copy the actual MSSQL repos(bypassing the configuration repos in the documentation), they're here...
    They're all here... MSSQL for SLES 11, SLES 12, SLES15 and of course SLES15 is supposed to be similar to openSUSE 15
    TSU
    I see you experienced a similar frustration with both as I did trying to figure out if MS SQL Server can work with Leap 15.x.

    I decided to buy another 4Tb drive and will perform the OpenSuse 15.1 install and will attempt to install MS SQL Server 2017 using the repository that you identified.

    I will report back what happens on my test on v15.1--I'm imagine others are curious too!!

    Thank you for your time and research!!

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •