Share via

SQL server update error for sqlserver2019-kb5040948-x64_08f7d8ccaa470bd969fe72d30aaa9b5de6ef7af3.exe reports no SQL Server instances

Gunnar Magnenat 0 Reputation points
2024-07-11T22:11:54.83+00:00

KB5040948 SQL Server update reports, "There are no SQL Server instances or shared features that can be updated on this computer"

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,039 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 28,351 Reputation points
    2024-07-12T01:53:35.8333333+00:00

    Hi @Gunnar Magnenat

    What is your SQL Server version?

    Please verify the version of SQL Server and the edition against the update package requirements and confirm that the update package (kb5040948) is compatible with the version and edition of SQL Server installed on your machine.

    Best regards,

    Cosmog

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

  2. Erland Sommarskog 112.8K Reputation points
    2024-07-12T22:13:28.96+00:00

    Thank you for the reply. Upon checking the SQL version with a Select @@version query in SSMS the version, 15.0,4382.1, matches the version listed in KB5040948. The update falsely reported a failure.

    No, I think the Update is correct. To wit, this is what "SELECT @@version" reports on my machine:

    Microsoft SQL Server 2019 (RTM-CU27-GDR) (KB5040948) - 15.0.4382.1 (X64) Jul 1 2024 20:03:23 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 22631: )

    That is, you already have the GDR installed.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.