ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    MS SQL Server 2016 on Windows Server 2019?

    IT Discussion
    sql server sql server 2016 windows server 2019
    7
    15
    2.2k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • scottalanmillerS
      scottalanmiller
      last edited by

      Trying to find this info while on a call. Will SQL Server 2016 happily live on Server 2019? Have an app that won't let us update the database, but I'd prefer to keep at least the OS up to date.

      GreyG IRJI 2 Replies Last reply Reply Quote 0
      • GreyG
        Grey @scottalanmiller
        last edited by

        @scottalanmiller said in MS SQL Server 2016 on Windows Server 2019?:

        Trying to find this info while on a call. Will SQL Server 2016 happily live on Server 2019? Have an app that won't let us update the database, but I'd prefer to keep at least the OS up to date.

        Yes. SQL really doesn't give a shit except for a few select versions where it needs specific capabilities of the OS like VSS.

        1 Reply Last reply Reply Quote 1
        • jt1001001J
          jt1001001
          last edited by

          I am running SQL standard 2016 on server 2019 I do not know if its "supported" but it is working and so far no issues; granted very small DB may 400MB but its what the vendor wanted.

          scottalanmillerS 1 Reply Last reply Reply Quote 1
          • IRJI
            IRJ @scottalanmiller
            last edited by

            @scottalanmiller said in MS SQL Server 2016 on Windows Server 2019?:

            Trying to find this info while on a call. Will SQL Server 2016 happily live on Server 2019? Have an app that won't let us update the database, but I'd prefer to keep at least the OS up to date.

            That really makes things expensive. It would be nice to run it on Linux. I would find out if it can support SQL 2017.

            T scottalanmillerS 2 Replies Last reply Reply Quote 0
            • T
              thecreaitvone91 @IRJ
              last edited by

              @IRJ said in MS SQL Server 2016 on Windows Server 2019?:

              @scottalanmiller said in MS SQL Server 2016 on Windows Server 2019?:

              Trying to find this info while on a call. Will SQL Server 2016 happily live on Server 2019? Have an app that won't let us update the database, but I'd prefer to keep at least the OS up to date.

              That really makes things expensive. It would be nice to run it on Linux. I would find out if it can support SQL 2017.

              Good point, why waste a windows license?

              Actually you can: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup?view=sql-server-ver15

              IRJI scottalanmillerS 2 Replies Last reply Reply Quote 0
              • IRJI
                IRJ @thecreaitvone91
                last edited by

                @thecreaitvone91 said in MS SQL Server 2016 on Windows Server 2019?:

                @IRJ said in MS SQL Server 2016 on Windows Server 2019?:

                @scottalanmiller said in MS SQL Server 2016 on Windows Server 2019?:

                Trying to find this info while on a call. Will SQL Server 2016 happily live on Server 2019? Have an app that won't let us update the database, but I'd prefer to keep at least the OS up to date.

                That really makes things expensive. It would be nice to run it on Linux. I would find out if it can support SQL 2017.

                Good point, why waste a windows license?

                Actually you can: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup?view=sql-server-ver15

                YEah but its 2017 not 2016 like I mentioned

                scottalanmillerS 1 Reply Last reply Reply Quote 0
                • GreyG
                  Grey
                  last edited by

                  Also https://docs.nethserver.org/en/v7/mssql.html.

                  IRJI 1 Reply Last reply Reply Quote 0
                  • IRJI
                    IRJ @Grey
                    last edited by

                    @Grey said in MS SQL Server 2016 on Windows Server 2019?:

                    Also https://docs.nethserver.org/en/v7/mssql.html.

                    yuck lol.

                    I would not run that any all in one server like Neth.

                    1 Reply Last reply Reply Quote 0
                    • scottalanmillerS
                      scottalanmiller @jt1001001
                      last edited by

                      @jt1001001 said in MS SQL Server 2016 on Windows Server 2019?:

                      I am running SQL standard 2016 on server 2019 I do not know if its "supported" but it is working and so far no issues; granted very small DB may 400MB but its what the vendor wanted.

                      Thanks

                      1 Reply Last reply Reply Quote 0
                      • scottalanmillerS
                        scottalanmiller @IRJ
                        last edited by

                        @IRJ said in MS SQL Server 2016 on Windows Server 2019?:

                        @scottalanmiller said in MS SQL Server 2016 on Windows Server 2019?:

                        Trying to find this info while on a call. Will SQL Server 2016 happily live on Server 2019? Have an app that won't let us update the database, but I'd prefer to keep at least the OS up to date.

                        That really makes things expensive. It would be nice to run it on Linux. I would find out if it can support SQL 2017.

                        It actually doesn't. For a variety of reasons...

                        1. 2016 is available on Linux, too.
                        2. They get a 2016 license with their app, they don't get 2017 so they'd have to pay tons more for it.
                        3. Because of other Windows licensing needs, they have to have Windows Standard already and the VM for SQL Server is the "free" second VM (or fourth, in this case).
                        4. Because Windows is required for three of their workloads, we already have to have the Windows skill met, and this would be the only Linux workload in the environment.

                        Trust me, we tried to go Linux. But it just didn't work out.

                        ObsolesceO 1 Reply Last reply Reply Quote 0
                        • scottalanmillerS
                          scottalanmiller @thecreaitvone91
                          last edited by

                          @thecreaitvone91 said in MS SQL Server 2016 on Windows Server 2019?:

                          @IRJ said in MS SQL Server 2016 on Windows Server 2019?:

                          @scottalanmiller said in MS SQL Server 2016 on Windows Server 2019?:

                          Trying to find this info while on a call. Will SQL Server 2016 happily live on Server 2019? Have an app that won't let us update the database, but I'd prefer to keep at least the OS up to date.

                          That really makes things expensive. It would be nice to run it on Linux. I would find out if it can support SQL 2017.

                          Good point, why waste a windows license?

                          Actually you can: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup?view=sql-server-ver15

                          Because we have nothing else to use it on.

                          1 Reply Last reply Reply Quote 0
                          • scottalanmillerS
                            scottalanmiller @IRJ
                            last edited by

                            @IRJ said in MS SQL Server 2016 on Windows Server 2019?:

                            @thecreaitvone91 said in MS SQL Server 2016 on Windows Server 2019?:

                            @IRJ said in MS SQL Server 2016 on Windows Server 2019?:

                            @scottalanmiller said in MS SQL Server 2016 on Windows Server 2019?:

                            Trying to find this info while on a call. Will SQL Server 2016 happily live on Server 2019? Have an app that won't let us update the database, but I'd prefer to keep at least the OS up to date.

                            That really makes things expensive. It would be nice to run it on Linux. I would find out if it can support SQL 2017.

                            Good point, why waste a windows license?

                            Actually you can: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup?view=sql-server-ver15

                            YEah but its 2017 not 2016 like I mentioned

                            Yeah, can't use that nor 2019 for this workload. 2016 and older only.

                            1 Reply Last reply Reply Quote 0
                            • dbeatoD
                              dbeato
                              last edited by

                              The requirements shows that is supported...
                              https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-ver15
                              dde9adcd-c94c-4faa-a1f7-bd3b5b94f3a7-image.png

                              scottalanmillerS 1 Reply Last reply Reply Quote 1
                              • scottalanmillerS
                                scottalanmiller @dbeato
                                last edited by

                                @dbeato thanks, that table was hard to locate while on a call.

                                1 Reply Last reply Reply Quote 0
                                • ObsolesceO
                                  Obsolesce @scottalanmiller
                                  last edited by

                                  @scottalanmiller said in MS SQL Server 2016 on Windows Server 2019?:

                                  Trust me, we tried to go Linux. But it just didn't work out.

                                  OH NOES!

                                  1 Reply Last reply Reply Quote 0
                                  • 1 / 1
                                  • First post
                                    Last post