Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Why SQL Server Installer Sucks Today

Why SQL Server Installer Sucks Today

Scheduled Pinned Locked Moved The Lounge
databasesql-serversysadmin
20 Posts 9 Posters 0 Views 1 Watching
  • 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.
  • realJSOPR realJSOP

    It's an arbitrary restriction, and is being used to strong-arm people into migrating to Win10. Unacceptable.

    ".45 ACP - because shooting twice is just silly" - JSOP, 2010
    -----
    You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
    -----
    When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

    R Offline
    R Offline
    Ronny Japutra
    wrote on last edited by
    #8

    Can't argue with that, strong-arming people into the latest OS doesn't only happen in Windows. Same things happen if we have to use iOS / Android / etc etc. :sigh:

    1 Reply Last reply
    0
    • realJSOPR realJSOP

      It's an arbitrary restriction, and is being used to strong-arm people into migrating to Win10. Unacceptable.

      ".45 ACP - because shooting twice is just silly" - JSOP, 2010
      -----
      You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
      -----
      When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

      D Offline
      D Offline
      dandy72
      wrote on last edited by
      #9

      John Simmons / outlaw programmer wrote:

      It's an arbitrary restriction,

      Totally. Wouldn't be surprised *at all* if this was one of those cases where, if one hacked the OS check out of the installer, it would install and run perfectly. But knowing MS, they probably added a runtime check as well, so...

      R 1 Reply Last reply
      0
      • realJSOPR realJSOP

        It seems that SQL 2016 and higher can't be installed on Windows 7...

        ".45 ACP - because shooting twice is just silly" - JSOP, 2010
        -----
        You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
        -----
        When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

        D Offline
        D Offline
        David Crow
        wrote on last edited by
        #10

        If Visual Studio 6 can be installed (and used) on Windows 7, I'm curious why such a newer piece of software would not be able to.

        "One man's wage rise is another man's price increase." - Harold Wilson

        "Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

        "You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles

        realJSOPR 1 Reply Last reply
        0
        • realJSOPR realJSOP

          I was trying to install it in a VM on Linux.

          ".45 ACP - because shooting twice is just silly" - JSOP, 2010
          -----
          You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
          -----
          When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

          Kornfeld Eliyahu PeterK Offline
          Kornfeld Eliyahu PeterK Offline
          Kornfeld Eliyahu Peter
          wrote on last edited by
          #11

          Why? Install it on Linux directly: Installation guidance for SQL Server on Linux | Microsoft Docs[^]

          "The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge". Stephen Hawking, 1942- 2018

          "It never ceases to amaze me that a spacecraft launched in 1977 can be fixed remotely from Earth." ― Brian Cox

          realJSOPR 1 Reply Last reply
          0
          • D dandy72

            John Simmons / outlaw programmer wrote:

            It's an arbitrary restriction,

            Totally. Wouldn't be surprised *at all* if this was one of those cases where, if one hacked the OS check out of the installer, it would install and run perfectly. But knowing MS, they probably added a runtime check as well, so...

            R Offline
            R Offline
            Ronny Japutra
            wrote on last edited by
            #12

            dandy72 wrote:

            Totally. Wouldn't be surprised at all if this was one of those cases where, if one hacked the OS check out of the installer, it would install and run perfectly. But knowing MS, they probably added a runtime check as well, so...

            I'm sure hacking an OS is not an ordinary task for the ordinary Joe. To avoid all these hacking or these oh-so-many updates, moving to Linux is definitely a good idea. Linux seems to be able to support some really old hardware. Kudos to Linux. :thumbsup:

            realJSOPR D 2 Replies Last reply
            0
            • D David Crow

              If Visual Studio 6 can be installed (and used) on Windows 7, I'm curious why such a newer piece of software would not be able to.

              "One man's wage rise is another man's price increase." - Harold Wilson

              "Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

              "You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles

              realJSOPR Offline
              realJSOPR Offline
              realJSOP
              wrote on last edited by
              #13

              Because MS wrote the installer to disallow it. As someone else also mentioned, there are most likely runtime checks as well.

              ".45 ACP - because shooting twice is just silly" - JSOP, 2010
              -----
              You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
              -----
              When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

              1 Reply Last reply
              0
              • R Ronny Japutra

                dandy72 wrote:

                Totally. Wouldn't be surprised at all if this was one of those cases where, if one hacked the OS check out of the installer, it would install and run perfectly. But knowing MS, they probably added a runtime check as well, so...

                I'm sure hacking an OS is not an ordinary task for the ordinary Joe. To avoid all these hacking or these oh-so-many updates, moving to Linux is definitely a good idea. Linux seems to be able to support some really old hardware. Kudos to Linux. :thumbsup:

                realJSOPR Offline
                realJSOPR Offline
                realJSOP
                wrote on last edited by
                #14

                Ronny Japutra wrote:

                Linux seems to be able to support some really old hardware. Kudos to Linux.

                Don't get too comfortable there. Linux fan-boi claims that "Linux can run on a two-slice toaster", but seriously - how much real work can you do on a two slice toaster? If you want to run heavy duty servers, you need a crapload of CPUs and an even bigger crapload of RAM. In point of fact, if you want a responsive and attractive desktop experience, you STILL need the same hardware that you need for Windows, and for the same reasons. At the same time, you can run a XFCE windows manager on a well-built box, and the performance of the OS will blow you away.

                ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                -----
                You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                -----
                When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                1 Reply Last reply
                0
                • Kornfeld Eliyahu PeterK Kornfeld Eliyahu Peter

                  Why? Install it on Linux directly: Installation guidance for SQL Server on Linux | Microsoft Docs[^]

                  "The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge". Stephen Hawking, 1942- 2018

                  realJSOPR Offline
                  realJSOPR Offline
                  realJSOP
                  wrote on last edited by
                  #15

                  I can't really find whether or not there's a developer's edition available for Linux...

                  ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                  -----
                  You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                  -----
                  When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                  Kornfeld Eliyahu PeterK 1 Reply Last reply
                  0
                  • realJSOPR realJSOP

                    I can't really find whether or not there's a developer's edition available for Linux...

                    ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                    -----
                    You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                    -----
                    When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                    Kornfeld Eliyahu PeterK Offline
                    Kornfeld Eliyahu PeterK Offline
                    Kornfeld Eliyahu Peter
                    wrote on last edited by
                    #16

                    I do not think that there are 'editions' on Linux (I will try it later) - it depends on the license key you have...

                    "The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge". Stephen Hawking, 1942- 2018

                    "It never ceases to amaze me that a spacecraft launched in 1977 can be fixed remotely from Earth." ― Brian Cox

                    1 Reply Last reply
                    0
                    • realJSOPR realJSOP

                      It's an arbitrary restriction, and is being used to strong-arm people into migrating to Win10. Unacceptable.

                      ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                      -----
                      You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                      -----
                      When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                      N Offline
                      N Offline
                      Nathan Minier
                      wrote on last edited by
                      #17

                      That's weird. I sort of assumed that the issue was the runtime, but apparently .NET Core 2+ will run on Win 7. Yeah, that's arbitrary as hell.

                      "Never attribute to malice that which can be explained by stupidity." - Hanlon's Razor

                      realJSOPR 1 Reply Last reply
                      0
                      • N Nathan Minier

                        That's weird. I sort of assumed that the issue was the runtime, but apparently .NET Core 2+ will run on Win 7. Yeah, that's arbitrary as hell.

                        "Never attribute to malice that which can be explained by stupidity." - Hanlon's Razor

                        realJSOPR Offline
                        realJSOPR Offline
                        realJSOP
                        wrote on last edited by
                        #18

                        It's the same with SQL 2016. To illustrate that it's arbitrary, SSMS 2017 *can* be installed on Windows 7. So it's okay to manage a sql server 2017 instance from a Win7 box, but you can't install SQL server 2017 on a win7 box.

                        ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                        -----
                        You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                        -----
                        When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                        D 1 Reply Last reply
                        0
                        • R Ronny Japutra

                          dandy72 wrote:

                          Totally. Wouldn't be surprised at all if this was one of those cases where, if one hacked the OS check out of the installer, it would install and run perfectly. But knowing MS, they probably added a runtime check as well, so...

                          I'm sure hacking an OS is not an ordinary task for the ordinary Joe. To avoid all these hacking or these oh-so-many updates, moving to Linux is definitely a good idea. Linux seems to be able to support some really old hardware. Kudos to Linux. :thumbsup:

                          D Offline
                          D Offline
                          dandy72
                          wrote on last edited by
                          #19

                          I wasn't suggesting to hack the OS, but the *OS check* that's part of the installer. I've done this with the old Orca tool, which can crack open an MSI and let you do some minor modifications with very little risk of breaking anything. The OS check is just a small table.

                          1 Reply Last reply
                          0
                          • realJSOPR realJSOP

                            It's the same with SQL 2016. To illustrate that it's arbitrary, SSMS 2017 *can* be installed on Windows 7. So it's okay to manage a sql server 2017 instance from a Win7 box, but you can't install SQL server 2017 on a win7 box.

                            ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                            -----
                            You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                            -----
                            When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                            D Offline
                            D Offline
                            dandy72
                            wrote on last edited by
                            #20

                            Well...MS has a number of management tools/consoles that'll install on any client OS, to manage stuff that only runs on a server OS. The entire System Center suite comes to mind (Operations Manager, Configuration Manager, Data Protection Manager, Virtual Machine Manager, etc). OTOH the trend these days is to implement the management console in a browser, so it'll run everywhere.

                            1 Reply Last reply
                            0
                            Reply
                            • Reply as topic
                            Log in to reply
                            • Oldest to Newest
                            • Newest to Oldest
                            • Most Votes


                            • Login

                            • Don't have an account? Register

                            • Login or register to search.
                            • First post
                              Last post
                            0
                            • Categories
                            • Recent
                            • Tags
                            • Popular
                            • World
                            • Users
                            • Groups