Windows 10: After July 2021 Win 10 updates SQL 2019 Service fails to start

The SQL Server MSSQLSERVER service terminated with the following service-specific error: An attempt was made to access a socket in a way forbidden by its access permissions.

:)

 

Office 2019

Only supported on Win10. Sorry, 8.1 users, only 4 years old, gotta go.

Microsoft Office 2019 will only work on Windows 10

https://blogs.technet.microsoft.com...-to-office-and-windows-servicing-and-support/

Spoiler Office 2019
Last year at Ignite, we announced Office 2019 – the next perpetual version of Office that includes apps (including Word, Excel, PowerPoint, and Outlook, and Skype for Business) and servers (including Exchange, SharePoint, and Skype for Business). Today we’re pleased to share the following updates:

• Office 2019 will ship in H2 of 2018. Previews of the new apps and servers will start shipping in the second quarter of 2018.
• Office 2019 apps will be supported on:
  • Any supported Windows 10 SAC release
  • Windows 10 Enterprise LTSC 2018
  • The next LTSC release of Windows Server
• The Office 2019 client apps will be released with Click-to-Run installation technology only. We will not provide MSI as a deployment methodology for Office 2019 clients. We will continue to provide MSI for Office Server products.

 

SQL server 2019 upgrade checkpoints from SQL 2016

Hello Meraj,

I am Jaspreet Singh an independent advisor.

The main Pro of upgrading to SQL server 2019 will be the long term support which 2016 will be getting to the end of in 2021 (mainstream support ending)

Other Pro will be that 2019 update brought a bunch of new cutting edge features that have since been started to be used.

here is a comparison of these new features in 2019 with availability among 2016 and 2017 :

https://www.microsoft.com/en-in/sql-server/sql-...

But since most of these features are new 2019 update has all the issues that plague new releases and you should be ready to keep the updates rolling because you will be getting a lot of patches on pretty significant issues. Alongside that since the update has
been relatively new you will have to work out issues popping up on your own.

This blog summarizes it pretty well :
https://www.brentozar.com/archive/2019/01/which...

Disclaimer: this is a non Microsoft website. The page appears to be providing accurate and safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (potentially unwanted products). Throughly research any product
advertised on the site before you decide to download and install it

 

After update on July 9th 2019, Windows will not start

After the update on July 9th 2019, Windows will not start. Tried Startup Repair and restore and nothing works. Got an error code (0x80070020) Is there any suggestions please?