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

How do I sign into Amazon Prime on my Samsung Smart TV?

Prime Music   You can get to Prime Music with an Alexa-empowered gadget, Fire TV, Fire TV Stick or Fire Tablet yet in addition with Sonos, iPhone, Android telephones and tablets, PC/MAC, internet browsers, brilliant TVs and even a few vehicles. Access a large number of playlists, stations and tunes whenever and from anyplace. Your listening is continuous, promotion free and on-request with boundless skips and disconnected playback. How to interface?  For cell phones, download and dispatch the Amazon Music application on your gadget, at that point sign in utilizing data for your essential . Visit here for more details : norton.com/setup For Alexa-empowered gadgets, simply ask, "Alexa, play music" or request your main tune, craftsman or collection. For Fire TV Voice Remote, essentially press the mouthpiece catch on the Alexa Voice Remote and demand a melody. Furthermore, with no Voice Remote, simply explore to Your Apps and Games. Prime Reading  Prime ...
Post a Comment
Read more

Download the Latest Microsoft Intune Architecture Diagram

This article describes how to download the latest Microsoft Intune architecture diagram. You can download a high-level architecture for Microsoft Intune and use it as a reference to learn about Intune’s capabilities. The IT decision-makers and architects can use the illustrations to determine the ideal solutions for their workloads and to make decisions about core infrastructure components such as networking, identity, and security. If you are an Intune administrator, this high-level Microsoft Intune architecture diagram is very useful in understanding about the Intune product family. Microsoft adds several new features to Intune with every service release. I am confident this diagram will be updated in the future once Microsoft adds new services to Intune, such as advanced app management and cloud certification management capabilities. Until then, you can use this diagram to understand how Intune integrates with other solutions. https://fofabaike.com/forum.php?mod=viewthread&tid=5...
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