Why SQL Server Installer Sucks Today
-
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 -
That's what MS say: Hardware and Software Requirements for Installing SQL Server 2016 | Microsoft Docs[^] The compatibility list does start with Win8. And MS did end mainstream support for Windows 7 on January 13, 2015 (though extended support won't end until 2020). I wouldn't expect them to release new versions for unsupported OS's.
Sent from my Amstrad PC 1640 Never throw anything away, Griff Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!
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 -
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 -
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, 2013Can'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:
-
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, 2013John 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...
-
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, 2013If 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
-
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, 2013Why? 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
-
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...
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:
-
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
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 -
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:
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 -
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
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 -
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, 2013I 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'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, 2013That'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
-
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
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 -
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:
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.
-
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, 2013Well...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.
