MDAC components MSI Error: 1603

tomstaggtomstagg Posts: 3
edited November 9, 2015 6:00AM in SQL Search
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?
Tagged:
· Share on Twitter

Comments

  • Andrew PAndrew P Posts: 194 Silver 3
    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
    Andrew Pierce
    Technical Sales Engineer
    Redgate Software
    · Share on Twitter
  • tomstaggtomstagg Posts: 3
    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).
    · Share on Twitter
  • RVORVO Posts: 4 New member
    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.
    · Share on Twitter
  • Dan BDan B Posts: 287 Gold 5
    Hi RVO,

    I have passed on some troubleshooting steps via email. Please let me know if you don't receive this.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
    · Share on Twitter
  • RVORVO Posts: 4 New member
    edited June 1, 2017 3:06PM
    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...

    · Share on Twitter
  • RVORVO Posts: 4 New member
    How much is the license for SQL Toolbelt for let;s say 3 users?
    · Share on Twitter
  • Sam JSam J Posts: 13
    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.
    Customer Support | Redgate Software
    · Share on Twitter
Sign In or Register to comment.