When the upgrade guides give the approved SQL and Windows versions is that for the database server or would it apply to the app server as well?
Our SQL server is windows 2019 but the application server is 2016. I want to figure out if I can upgrade to SQL 2019 which is supported with Windows 2019 but not 2016
The Install Guides do list the valid combinations.
FWIW, support for WS 2016 ended 11 Jan 2022 if that helps.
Yes they do but im trying to understand if that is important on both the SQL server and the application server in a two server environment or if that predominantly applies to the SQL server
Our current SQL server is SQL 2017 on Windows 2019. Our app server is Windows 2016
SQL 2019 is only supported on Win 2019 so the SQL box is ok but trying to figure out if I need to move the app server to 2019 first or if only the SQL server is important
I’d say both are important. Separately, the SQL Compatibility level is important too. Functions like String_agg are not enabled until a certain level.
As Mark mentioned that the EOS of 2016 was 2022, so this would always be best to go for latest version (nothing new in it),
Secondly, any bug whose reason is unidentified would easily be put in old OS pocket.
