ConfigMgr and SQL ODBC Driver Prereqs

[dgalbreath]

Attempting to download the ConfigMgr prereqs with setupdl.exe per the instructions results in an error stating that the SQL ODBC Driver must be installed to continue. Attempting to install the SQL ODBC driver results in an error stating that Visual C++ Redistributable must be installed to continue. After installing the latest Visual C++ redist and ODBC driver, the ConfigMgr prereqs download successfully. You may want to add these steps to the instruction document.

I'm also assuming that the Visual C++ Redist error would be an issue during the CM01 TS since the ODBC Driver will not install without it. I've not made it far enough in my build to confirm that, but can report back if needed.

[githubphilmsn]

I had the same issue and fixed it like you but. Everything's fine for DC01, but when I try to install CM01, it bug at the Install ConfigMgr step in the TS. Here's the messages at the end of the ConfigMgrSetup.log on CM01.

*** spCreateIndex @indexName='Software_byprops_idx', @table='LU_SoftwareList', @type='', @indexColumns='CommonName, CommonVersion, CommonPublisher', @includeColumns='SoftwareID' $$<05-16-2025 13:29:02.575+420><thread=4992 (0x1380)>
*** [42000][681][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Attempting to set a non-NULL-able column's value to NULL. $$<05-16-2025 13:29:02.575+420><thread=4992 (0x1380)>
Failed to execute sql command spCreateIndex @indexName='Software_byprops_idx', @table='LU_SoftwareList', @type='', @indexColumns='CommonName, CommonVersion, CommonPublisher', @includeColumns='SoftwareID' ~ $$<05-16-2025 13:29:02.580+420><thread=4992 (0x1380)>
ERROR: Failed to execute SQL Server script: Creating indexes on LU_SoftwareList $$<05-16-2025 13:29:02.583+420><thread=4992 (0x1380)>
ERROR: SQL Server error: <> $$<05-16-2025 13:29:02.589+420><thread=4992 (0x1380)>
~Setup cannot create the required database tables. Contact your SQL administrator. $$<05-16-2025 13:29:02.593+420><thread=4992 (0x1380)>
~Setup has encountered fatal errors during database initialization. Contact your SQL administrator. $$<05-16-2025 13:29:02.596+420><thread=4992 (0x1380)>
Not recovery mode or not top level site. Skip restoring client piloting packages. $$<05-16-2025 13:29:02.601+420><thread=4992 (0x1380)>

The right version of ODBC 18 is installed,

I tried multiple version of SQL, tried a manual install of ConfigMgr, nothing works.

Do you have an idea?

Thank you

[arwidmark]

ConfigMgr 2503 requires ODBC 18.4 (think 18.5 works too), the link in the ConfigMgr prereq log is incorrect.

[vimal80-spec]

While running the Hydration Kit to build a ConfigMgr Lab, the CM01 virtual machine fails during the "Install - ConfigMgr" step of the Task Sequence. The failure occurs during the database initialization phase specifically when importing Asset Intelligence data.
I tried downloading source file and rebuild it again with no luck. Can you please help with this issue? Thanks.

ConfigMgrSetup.log