Since you cannot download a separate installer for the OS components, you should follow these steps if your application reports MDAC is missing: How to re-install MDAC on SQL server 2008? - Stack Overflow
Versions 2.8 and earlier were used on Windows XP and Server 2003. They were often available as separate downloads for developers. mdac download windows server 2008 r2
Because it is a core system component, there is no standalone "MDAC 2.8" installer for Windows Server 2008 R2. Attempting to run older redistributable installers like mdac_typ.exe will typically fail because the OS already contains a newer, integrated version (WDAC 6.1). Understanding MDAC vs. WDAC Since you cannot download a separate installer for
Included in Windows Server 2008 R2, it provides the same essential technologies—ActiveX Data Objects (ADO), OLE DB, and ODBC—but is serviced through Windows Update rather than separate installers. How to "Install" or Enable Data Access Components Because it is a core system component, there
For users looking to download for Windows Server 2008 R2 , the most important fact is that MDAC is already pre-installed as part of the operating system. In fact, starting with Windows Vista and Windows Server 2008, MDAC was renamed to Windows Data Access Components (WDAC) .