Microsoft SQL ODBC driver 18 Prerequisite For Upgrade v2309

Vid3al 91 Reputation points
2024-01-19T09:11:13.0033333+00:00

It is unclear where the "Microsoft ODBC Driver for SQL Server 18.1.0" should be installed.

The prerequisite check shows that it is not installed on the Site Server, and therefore you need to install it.

[Failed]:Install the Microsoft ODBC driver 18 for SQL setup from https://go.microsoft.com/fwlink/?linkid=2220989.

But from some online guides, it seems that it is necessary to install "Microsoft ODBC Driver for SQL Server 18.1.0", also on the Database Server, above the "SUP" and the "Distribution Points". In short, above all the servers that host and provide a Configuration Manager role.

In addition, version 17 is already present on the Database Server. Why doesn't the prerequisite check show that I need to install version 18 ?

https://techcommunity.microsoft.com/t5/configuration-manager-blog/update-2309-for-microsoft-configuration-manager-current-branch/ba-p/3928963

Do we need to install the "Microsoft ODBC Driver for SQL Server 18.1.0" on top of all these systems?

  • on the Site Server ? (No version of Microsoft ODBC Driver for SQL Server is installed).
  • on the Database Site Server ? (Version 17.10.3.1 is already installed).
  • on the Software Update Server ? (No version of Microsoft ODBC Driver for SQL Server is installed).
  • above the Distribution Points ? (No version of Microsoft ODBC Driver for SQL Server is installed).

Thank you for your patience and support.

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
892 questions
Microsoft Configuration Manager Updates
Microsoft Configuration Manager Updates
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Updates: Broadly released fixes addressing specific issue(s) or related bug(s). Updates may also include new or modified features (i.e. changing default behavior).
1,004 questions
Microsoft Configuration Manager
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Simon Ren-MSFT 31,756 Reputation points Microsoft Vendor
    2024-01-19T09:50:10.4533333+00:00

    Hi @Vid3al ,

    Thank you for posting in Microsoft Q&A forum.

    ==>Do we need to install the "Microsoft ODBC Driver for SQL Server 18.1.0" on top of all these systems?

    Per my experience, yes, we need to install Microsoft ODBC Driver 18 on every node that has the site system role installed before the upgrade process. Similar threads for your reference:

    SCCM 2309 upgrade failure

    Microsoft ODBC driver 18 for SQL setup Issue with SCCM 2309 Upgrade

    Thanks for your time. Have a nice day!

    Best regards,

    Simon

    If the response 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.

  2. Simon Ren-MSFT 31,756 Reputation points Microsoft Vendor
    2024-01-31T09:46:32.11+00:00

    Hi,

    Hope everything goes well. Do you need any further assistance about this issue? If yes, please feel free to let us know, we will do our best to help you.

    If the response is helpful, it's appreciated that you could click "Accept Answer" and upvote it, this will help other users to search for useful information more quickly.

    Thanks for your time.

    Best regards,

    Simon