Bize Ulaşın / Contact Us

WinPE AdoDB SQL Connection Error (429)

26 / 11 / 2012 by SCCM / Configuration Manager 1 Yorum / Comment

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 can’t 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 connection.

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\boot.csrx64.wim /index:1 /MountDir:G:\WimWork\x64
  • dism /image:G:\WIMWork\csrx64 /Add-Package /PackagePath:”C:\Program Files\Windows AIK\Tools\PETools\amd64\WinPE_FPs\winpe-mdac.cab”
  • dism /unmount-image /MountDir:G:\WIMWork\csrx64 /Commit

Now I have necessary libraries in my new boot image and it can connect to SQL server.

Note : Don’t forget to change Netlib value to DBMSSOCN in your CustomSettings.ini if you will use SQL Authentication instead of Windows Authentication.

One comment on “WinPE AdoDB SQL Connection Error (429)

  1. on May 29, 2013
    Anonymous says:

    great Info Thanks !!!! i do this like you describe it and it works perfect :)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

*

Kontrol / Control * Time limit is exhausted. Please reload CAPTCHA.