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

Popular posts from this blog

How to Connect your Xbox One to iOS Device ?

Microsoft's devoted Xbox cell phone application is an extraordinary route for players to remain drew in with their gaming companions while in a hurry. Like Sony's PlayStation application, the Xbox application enables clients to buy diversions, share content, see their accomplishments, and send updates to their supporters on Xbox Live. It likewise gives extra devices to review accomplishments, controlling motion picture playback, and getting to social components, for example, profiles and informing, which is all significantly more advantageous than signing onto your reassure or PC to do a similar thing. https://www.direct-directory.com/index.php?p=d https://www.dbsdirectory.com/index.php?p=d   get more information visit here  : www.office.com/setup Everything necessary to oversee your Xbox experience is a tad of tolerance. The procedure for blending your gadgets is presently less demanding than at any other time, so read on for our brisk guide on the most proficient me...

A Collection of Lesson Plans for Teaching Microsoft Office

These benefits help you train your understudies ventures, for instance, Word, Excel, PowerPoint, OneNote, Access, and Publisher inside the setting of authentic circumstances. visit here for more details : hulu.com/activate https://kunwal.kinja.com/what-youtube-premium-is-and-how-to-sign-up-1842017707?rev=1583132756466 Find exercise plans for simple, focus assessment, or auxiliary school understudies. Some may even be legitimate for fundamental PC classes at the school level. Best of all, most by far of these are free! 01 In any case, Check Your School District's Site  Most educators know whether their school area offers PC capacities instructive projects or exercise plans. https://sites.google.com/site/ecoword016/ http://misha001.booklikes.com/post/2071089/top-office-software-and-apps-for-the-windows-phone https://pastelink.net/1d6b6 Some school region even post free resources on the web, so you can research and perhaps download resources. If you are new to an app...

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