This tutorial explains how you can repair the Microsoft ODBC driver for SQL Server installation. If you’re experiencing runtime errors, installation errors with the ODBC driver, repairing will resolve those issues.
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. I have covered in detail this prerequisite in the SCCM 2309 upgrade guide.
At work, I dealt with a number of ODBC driver issues, some of which were critical, while others were primarily connection-related and necessitated the update of the ODBC driver to the most recent version. When the ODBC driver for SQL Server crashed, it was necessary to reinstall it. Microsoft has a dedicated page containing a listing of bugs fixed in each release, starting with ODBC Driver 17 for SQL Server.
Also Read: Fix SQL Client Prerequisite missing for SCCM Setup Error
Steps to repair Microsoft ODBC Driver for SQL Server
Follow the below steps to repair the ODBC driver for SQL Server on your Windows computer.
Step 1: Launch the Control Panel and go to Programs > Programs and Features. From the list of programs, select the Microsoft ODBC driver for SQL Server and select Change.
Step 2: On the Welcome to ODBC driver for SQL Server setup screen, click Next.
Step 3: On the Program Maintenance window, choose the “Repair” option.
Step 4: To begin the program repair, click Install. Clicking Install will repair installation errors in the program and fix missing or corrupted files, shortcuts, and registry entries.
Step 5: The ODBC Driver for SQL Server is successfully repaired now. Close the setup window. There is no system restart required after the program repair, but you can go ahead and reboot if required.
