Friday, June 15, 2018
WinPE AdoDB SQL Connection Error 429
WinPE AdoDB SQL Connection Error 429
I was using MDT wDB for OS deployments, now I am creating the same (better) system with SCCM for wider and easier deployment. I prefer MDT integration to SCCM as it provides lots of flexibility and customizability.
Today, I wanted to use MDT DB with my SCCM OSD, so I created a new MDT Settings package and copied my old CustomSettings.ini from MDT and customized. Duplicated my current build TS and changed the MDT Settings package in respective Gather actions.
Deployed a test machine and found out no localization settings have applied. So I found the error "Unable to create ADODB.Connection object, impossible to query SQL Server: ActiveX component cant create object (429)" in logs. After a few web search I found MDT Boot image usage is recommended as it has necessary libraries to create ADODB connections.
As usual I wanted to fix that instead of using my old MDT boot image, checked WinPE_FPs folder in WAIK and seen there is a winpe-mdac.cab (MS Data Access Components) and added this package to boot image.
- dism /mount-wim /WimFile:g:wimwork oot.csrx64.wim /index:1 /MountDir:G:WimWorkx64
- dism /image:G:WIMWorkcsrx64 /Add-Package /PackagePath:"C:Program FilesWindows AIKToolsPEToolsamd64WinPE_FPswinpe-mdac.cab"
- dism /unmount-image /MountDir:G:WIMWorkcsrx64 /Commit
Now I have necessary libraries in my new boot image and it can connect to SQL server.
Note : Dont forget to change Netlib value to DBMSSOCN in your CustomSettings.ini if you will use SQL Authentication instead of Windows Authentication.
