question

AndrewDerkatshew-1111 avatar image
0 Votes"
AndrewDerkatshew-1111 asked CsabaEgyd-9776 answered

sql server 2019 update kb4583458 error

while updating windows 10 with win updater i met an error - 0x80070643
then i tried to install diectly from microsoft site
installation goes through all phases up and checks
but there was another error - 0x851a0042
without it i cant end updating my win 10

111595-%D1%81%D0%BA%D1%80%D0%B8%D0%BD%D1%88%D0%BE%D1%82-04-07-2021-201506.png111606-%D1%81%D0%BA%D1%80%D0%B8%D0%BD%D1%88%D0%BE%D1%82-04-07-2021-201909.png111644-summary-xgamez-%D0%BF%D0%BA-20210704-195610.txt


sql-server-generalwindows-server-update-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
0 Votes"
DSPatrick answered

Might try the manual steps here.
https://docs.microsoft.com/en-us/windows/deployment/update/windows-update-resources#reset-windows-update-components-manually

--please don't forget to upvote and Accept as answer if the reply is helpful--



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi AndrewDerkatshew-1111,

Welcome to Microsoft Q&A.
Could you please share us the related error message in detail.txt within %programfiles%\Microsoft SQL Server\150\Setup Bootstrap\Log\YYYYMMDD_hhmmss?
And please refer to this article which might help.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

Rather than installing the GDR for the RTM verison, I strongly recommend that you apply the most recent Cumulative Update (which includes the security fix) for SQL 2019, which is CU11: https://support.microsoft.com/en-us/topic/kb5003249-cumulative-update-11-for-sql-server-2019-657b2977-a0f1-4e1f-8b93-8c2ca8b6bef5

Not that I expect the installation of CU11 to succeed, as presumably there is a problem on your machine that causes the installation to fail. But there is no reason to fight with a GDR that is out of date.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AndrewDerkatshew-1111 avatar image
0 Votes"
AndrewDerkatshew-1111 answered ErlandSommarskog commented

here txt report 111740-detail.txt



detail.txt (2.7 MiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I was not able to make out much of it. I found these two lines:

(01) 2021-07-04 23:31:58 Slp: Attempting to run patch request for instance: SQLEXPRESS
(01) 2021-07-04 23:32:23 Slp: Error: Failed to run patch request for instance: SQLEXPRESS (exit code: -2061893566)

So this is where it goes wrong - but why? We are not told, save for the exit code.

0 Votes 0 ·
CsabaEgyd-9776 avatar image
0 Votes"
CsabaEgyd-9776 answered

I know it is kind of late, but I have faced this error today on a new PC and managed to fix. I hope someone will find this info useful.

I had the same Windows Update error code for the update. I went for downloading the update package directly from the Microsoft Download Center.

Links:
https://support.microsoft.com/hu-hu/topic/kb4583458-description-of-the-security-update-for-sql-server-2019-gdr-january-12-2021-65859e33-296d-0b7d-5e13-69bbb6fb6974
https://www.microsoft.com/en-us/download/details.aspx?id=102618

Then running the update package manually I received the following error:
"The User Data directory in the registry is not valid."

I found this article and the fix was working:
https://blog.sqlauthority.com/2015/05/16/sql-server-service-pack-error-the-user-data-directory-in-the-registry-is-not-valid-verify-defaultdata-key-under-the-instance-hive-points-to-a-valid-directory/

After fixing the paths in the registry (DefaultData, DefaultLog, BackupDirectory) the installer was running without any errors.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.