Share via

Upgrade required

Salil Singh 20 Reputation points
2024-05-29T18:03:08.4666667+00:00

Hi Team,

I am having SQL Server 2022 Developer edition on my windows machine.

I need to upgrade below (to avoid any security vulnerability) -

  1. SQL Server 2022 Developer edition
  2. OLEDB
  3. ODBC

Please let me know the steps(links) for same.

Let me know if more information is required.

Thanks,

Salil

SQL Server on Azure Virtual Machines
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,946 questions

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 44,931 Reputation points
    2024-05-29T18:22:33.0066667+00:00

    I need to upgrade below

    Upgrade to what, there is no newer version then SQL Server 2022???

    You can only install latest CU13

    https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2022/cumulativeupdate13

  2. Ben Miller-(DBADuck) 110 Reputation points MVP
    2024-05-29T21:25:47.9133333+00:00
    0 comments
  3. Ben Miller-(DBADuck) 110 Reputation points MVP
    2024-05-29T21:27:05.1633333+00:00

    This was a duplicate.

  4. Erland Sommarskog 112.5K Reputation points MVP
    2024-05-29T21:31:11.24+00:00

    So the understanding is once SQL Server 2022 Developer edition is installed, User can not upgrade it to cover any security vulnerability. All user can do is to install latest CU13.

    The Cumulative Updates includes various fixes, including addressing known security vulnerabilities.

    Furthermore, if a security issue is uncovered, Microsoft will also publish a GDR to address that issue. The GDR will be pushed out through Windows Update.

    Such a GDR was published for CU12. This fix is included in CU13, and no GDR has been published for CU13.

    When it comes to OLE DB and ODBC, you can find the latest OLE DB driver here. Note that this page will give you MSOLEDBSQL19, which is a later version. Roll down the page to find the section about older releases. To use the newer version, you need to change the connection string.

    I'm too lazy too look up the ODBC driver for you, but the same principle applies here. The latest version is ODBC 18, but to use that driver, you need to change the connection string.

  5. LucyChenMSFT-4874 5,060 Reputation points
    2024-05-30T06:42:55.6233333+00:00

    Hi @Salil Singh ,

    Thanks for your feedback.

    What exact change is connection string is required here.

    To know more about the changes in the latest OLE DB 19 for SQL Server, you can check out this article.

    As Erland says,

    The Cumulative Updates includes various fixes, including addressing known security vulnerabilities.

    You can update the latest Cumulative Update for SQL Server if you are worrying about security.

    Will it be ok to uninstall these current drivers (as mentioned in #1 above) and install the latest versions.

    Hope this article can help you resolve the issue.

    User's image

    Please feel free to share your issue here if you have any confused.

    Best regards,

    Lucy Chen

    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".

    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.

    https://docs.microsoft.com/en-us/answers/support/email-notifications

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.