Latest ODBC Driver 18 for SQL (18.7.1.1) breaks SCCM Site Server > SQL connectivity

What worked for us:

Fix: On both our SCCM Site server and SCCM DP

o Uninstalled

    x Microsoft ODBC Driver 18 for SQL Server 18.7.1.1 (MSI-x64)

    x https://learn.microsoft.com/en-gb/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver16

o Download and Installed

    x Microsoft ODBC Driver 18 for SQL Server 18.6.2.1 (MSI-x64)

    x https://learn.microsoft.com/en-gb/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver16

Prevention: To prevent the 18.7.1.1 x64 update from being deployed again we

o Declined update

    x Microsoft ODBC Driver 18 for SQL Server 18.7.1.1 (MSI-x64)

    x https://learn.microsoft.com/en-gb/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver16

o Updated our ADR filter to exclude this update

    x Title is set to below (the "-" will filter it from ADR)

-Microsoft ODBC Driver 18 for SQL Server 18.7.1.1 (MSI-x64)

o In PatchMyPC we paused this update for 6 months

We'll look out for a future SCCM hotfix\update for this issue.