MDAC components MSI Error: 1603

tomstagg

I tried to update to SQL Search 2.0 from 1.0 and the installation failed with:

You must have the MDAC components installed in order to install this product. (MSI Error: 1603)

I saw this: viewtopic.php?t=10563 but it's not the same issue.

I checked my registry and I have Version 6.1.7601.17514 in HKEY_LOCAL_MACHINESoftwareMicrosoftDataAccess.
I'm using Windows 7 x64 machine.

installation log is too long to paste here, but shows:
...
[2015-02-25 11:49:48] System.ComponentModel.Win32Exception (0x80004005): A 32 bit processes cannot access modules of a 64 bit process.
at System.Diagnostics.NtProcessManager.GetModuleInfos(Int32 processId, Boolean firstModuleOnly)
at System.Diagnostics.NtProcessManager.GetFirstModuleInfo(Int32 processId)
at System.Diagnostics.Process.get_MainModule()
at RedGate.InstallerWizard.Engine.ProductSet.FindProgramsRunning(IList`1& running)
...
[2015-02-25 11:50:05] MSI: Error- You must have the MDAC components installed in order to install this product
[2015-02-25 11:50:05] RedGate.InstallerWizard.Engine.SQLToolbeltInstallerException: You must have the MDAC components installed in order to install this product (MSI Error: 1603)

Anyone have any ideas how to resolve?

Andrew P

Hello Tom,

Thanks for posting your question!
We will follow up with you via email to further troubleshoot and resolve this.

Warmly,
Andrew Pierce
Product Support Engineer
Redgate

tomstagg

I had this problem again when upgrading SQL Source Control from v 4.0 to 4.1. The resolution for me was to uninstall SQL Source Control first before reinstalling from re-downloaded SQLDeveloperSuite.exe (via download link on redgate page).

RVO

Hi Redgate.
I have the same issue. I am installing SQL Developer Bundle (SQL Compare 11, etc.)
I have Microsoft SQL Server Management Studio installed on my PC.
It shows that
Microsoft Data Access Components (MDAC) 6.1.7601.17514
already is installed on my PC.

Can you please help?
Thanks.

Dan B

Hi RVO,

I have passed on some troubleshooting steps via email. Please let me know if you don't receive this.

RVO

Thanks Dan.

By default users are not allowed to do any installations on their PC's in our bank.
SQL Developer Bundle was on "approved software list".
When you run the installation direclty from that "approved software list"" on intranet - it would bypass Security check and allow users to install.

My only choice is to communicate this to our bank managers who administer "approved software list"
and see if they can replace SQL Developer Bundle with SQL Toolbelt.

I was also hoping that MDAC error can be bypassed somehow with your help...
. . .you wrote . . .
As a first troubleshooting step, can you try to uninstall and reinstall by going through the following steps:
<Here> is a utility called Microsoft Cleanup Utility . . .

<Here> link points to https://www.dropbox.com. It is blocked in our company.
What exactly that link is for?
I guess if it's an executable it won't let me run it...

RVO

How much is the license for SQL Toolbelt for let;s say 3 users?

Sam J

Hi @RVO

Someone will be in touch with you shortly regarding pricing for this.

In the meantime if you need anything further please get in touch.