Skip to main content

Fix SQL Client Prerequisite missing for SCCM Setup Error

While upgrading to Configuration Manager version 2309 or later, you may encounter a prerequisite check error: SQL Client Prerequisite missing for SCCM setup. This article will explain why you get this error during the prerequisite check and how to resolve it.

When installing the most recent Configuration Manager update or any hotfix, you must always run a prerequisite check first. The prerequisite checks include a series of steps that are run against Configuration Manager components and the database to determine if the update installs correctly.

Starting with version 2309, Configuration Manager requires the installation of Microsoft ODBC driver 18 or later for SQL Server as a prerequisite. This prerequisite is required when you create a new site or update an existing one. We have covered this prerequisite in the SCCM 2309 upgrade guide.


http://forums.fanntic.com/viewtopic.php?t=62506

http://forums.fanntic.com/viewtopic.php?t=57625

http://orphe7.free.fr/forum/viewtopic.php?p=10185

http://orphe7.free.fr/forum/viewtopic.php?t=1889

http://eldoradofus.free.fr/forum/viewtopic.php?pid=10730

http://eldoradofus.free.fr/forum/viewtopic.php?pid=12777

http://chateaugarom.free.fr/anime/forum/viewtopic.php?t=383&view=next

http://chateaugarom.free.fr/anime/forum/viewtopic.php?t=3071&view=previous

http://djys24real2bl.caffei.ne.kr/board/bbs/board.php?bo_table=free&wr_id=17047

https://peppanews.com/bbs/board.php?bo_table=free&wr_id=57673

https://www.cnmontessori.co.kr/bbs/board.php?bo_table=free&wr_id=100624


Fix SQL Client Prerequisite missing for SCCM Setup Error


While upgrading SCCM to the latest version, you encounter the prerequisite check error “SQL Client Prerequisite missing for SCCM Setup” because of the missing ODBC driver for SQL Server. To resolve this error, download and install the most recent version of the Microsoft ODBC driver for SQL Server (18.0 or newer).

In the screenshot below, we see the Configuration Manager 2309 prerequisite check showing as failed. You see this error when you navigate to Monitoring > Overview > Updates and Servicing Status. You cannot install Update 2309 unless you resolve this error. To view the prerequisite check error, right-click on the update and select View Status.

On the Update Pack Installation Status window, we see an error during the prerequisite check step: “SQL client prerequisite missing for Config Manager setup“. When you select this prerequisite check step, the following details are listed in the error description:

Thanks to Microsoft, the error description contains the link to download the latest version of the Microsoft ODBC driver for SQL Server. Use that link to get the latest version of the Microsoft ODBC driver for SQL Server and install it on the server to get rid of the prerequisite check error.


Step 1: Check the installed SQL Server ODBC Driver version


Before installing the latest Microsoft ODBC Driver for SQL Server, let’s check the installed version on the SCCM server. Go to Control Panel > Programs > Programs and Features. From the screenshot below, we see the Microsoft ODBC Driver 17 for SQL Server is installed, and the version is 17.10.3.1.


Step 2: Download ODBC driver for SQL server


Use the following download link to get the most recent version of the ODBC driver for SQL Server. On the download page, select Download Microsoft ODBC Driver 18 for SQL Server (x64). The browser now downloads the msodbcsql.msi file to your computer.

According to Microsoft, the Microsoft ODBC Driver 18 for SQL Server can coexist with the Microsoft ODBC Driver 17 for SQL Server during installation. In other words, you don’t have to remove the older ODBC Driver 17 for SQL Server. If you don’t want to keep the older version of ODBC drivers, you can remove them after installing the latest version.


https://www.visualchemy.gallery/forum/viewtopic.php?id=1855156

https://www.visualchemy.gallery/forum/viewtopic.php?id=444062

http://pedelecforum.epowerbikes.at/viewtopic.php?t=160937

http://pedelecforum.epowerbikes.at/viewtopic.php?f=11&t=500063

http://pedelecforum.epowerbikes.at/viewtopic.php?f=11&t=45971

http://www.hondaikmciledug.co.id/HRIS/showthread.php?tid=2204&pid=3855#pid3855

https://ordemdospsicologos.org/forum/showthread.php?tid=1939

https://australiantravelforum.com/travel/showthread.php?tid=111

http://molbiol.ru/forums/index.php?showtopic=598190

http://www.izolacniskla.cz/forum-detail.php?dt_id=25673


Step 3: Install Microsoft ODBC Driver for SQL Server


In this step, we will install the ODBC driver for SQL Server. Launch msodbcsql.msi, and on the setup screen, click Next.

Select I accept the terms in the license agreement and click Next.

On the Feature Selection page, select the components that you want to install. In this case, we will install both Client Components and the ODBC Driver for SQL Server SDK. Click Next.

To begin the installation, select Install. The ODBC Driver 18 for SQL Server is now installed. Close the setup wizard.

To verify if the ODBC Driver 18 for SQL Server is installed, go to Control Panel > Programs > Programs and Features. From the screenshot below, we see the ODBC Driver version 18.3.1.1 for SQL Server has been installed successfully. After installing the SQL Server ODBC driver, you don’t have to restart the server, although we recommend doing so.


Step 4: Run the Prerequisite Check


After installing the ODBC Driver 18 for SQL Server, let’s run the prerequisite check and see if that has resolved the error: SQL client Prerequisite missing for SCCM setup. In the Configuration Manager console, go to Administration\Overview\Updates and Servicing. Right-click Configuration Manager 2309 update and select Run Prerequisite Check.


Comments

Post a Comment

Popular posts from this blog

Complete SCCM 2309 Upgrade Guide

This article demonstrates how to perform the SCCM 2309 upgrade and lists all the new features added in Configuration Manager version 2309. The steps covered in this guide will help you upgrade your ConfigMgr environment in your production to version 2309. ConfigMgr 2309 is a production-ready release, and it is the second current branch release of 2023. ‘2309’ stands for the year 2023 and ’09’ for the month of September. Your SCCM site must be running version 2203 or later to install update 2309. The most recent fixes and new features are added to your site after you upgrade to SCCM current branch, version 2309. Microsoft has made available a brand-new SCCM current branch version 2309 for the year 2023. This update includes several new features and updates that were previously seen in the technical preview releases. The ConfigMgr update 2309 for the current branch is available as an in-console update. You can install SCCM update 2309 on sites that run version 2203 or later. Before the r...
Post a Comment
Read more

Make Turkey Day Easy With Free Thanksgiving Templates for MS Word

Regardless of whether you're searching for an exquisite blowout or an agreeable, carefree Thanksgiving, these free Microsoft Word layouts can help with the readiness. visit here for more details : norton.com/setup These instant instruments can truly make all the difference with regards to solicitations, beautifications, menus, and that's only the tip of the iceberg. Step by step instructions to Get These Free Thanksgiving Templates  Dissimilar to different layouts that are accessible as downloads, these are open legitimately inside Microsoft Word. https://www.blackandbluedirectory.com/index.php?p=d https://www.blackandbluedirectory.com/index.php?p=d To discover these formats, open a clear or existing Word record, and after that go to File > New. From that point, look for the layout as depicted underneath, click it, and afterward select Create to open it in Word. click here : norton setup 01  Thanksgiving Cards Template for Invitations or Recipe Cards...
Post a Comment
Read more

How to Find a Word in Word ?

incorporates a pursuit work that makes it simple to look for a wide range of components in an archive, including content. Utilize the fundamental instrument to search for cases of a particular word, or the propelled choices to do things like supplant all occasions of a word with another or look for conditions. https://kunwal.kinja.com/what-it-is-and-how-to-protect-yourself-against-it-1842324940?rev=1584161419440 https://www.techsite.io/p/1402148 NOTE:- Instructions in this article apply to Word 2019, 2016, 2013, 2010; Word for Office 365, and Word Online. visit here norton setup for more details. https://sites.google.com/site/viruscrime01/ https://www.reddit.com/user/miral016/comments/fid6hw/what_is_pharming_find_out_about_the_scam/ https://justpaste.it/6w9fg Play out a Basic Word Search  https://share.nuclino.com/p/Office-365-versus-Office-2019-Which-is-better-sBU4k3K9HjkKkLkTWkIyAN https://www.articleted.com/articles.php https://www.bloglovin.com/@monika6697/10-bes...
Post a Comment
Read more