sql server 2019 update kb4583458 error

Andrew Derkatshew 1 Reputation point
2021-07-04T17:27:00.677+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,642 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,082 questions
0 comments No comments
{count} votes

5 answers

Sort by: Most helpful
  1. Dave Patrick 426K Reputation points MVP
    2021-07-04T18:33:57.973+00:00

    Might try the manual steps here.
    https://learn.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--

    0 comments No comments

  2. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-07-05T06:38:38.89+00:00

    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.

    0 comments No comments

  3. Erland Sommarskog 100.8K Reputation points MVP
    2021-07-05T07:44:30.78+00:00

    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.

    0 comments No comments

  4. Andrew Derkatshew 1 Reputation point
    2021-07-05T12:23:03.26+00:00

    here txt report 111740-detail.txt


  5. Csaba Együd 1 Reputation point
    2022-04-20T10:00:49.787+00:00

    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.

    0 comments No comments