Post reply

SQL 2014 Upgrade Advisor install fails

  • July 2, 2014 at 12:19 pm

    #296267

    Hey there,

    I've installed SQL 2014 Enterprise on a VM and am trying to install the Upgrade Advisor.

    Directions indicate that I should run SqlUA.msi but I get the following error:

    ========================================

    Setup is missing prerequisites:

    -Microsoft SQL Server 2014 Transact-SQL-ScriptDom, which is not installed by Upgrade Advisor Setup. To continue, install SQL Server 2014 Transact-SQL ScriptDom from below hyperlink and then run the Upgrade Advisor Setup operation again :

    Go to http://go.microsoft.com/fwlink/?LinkID=296473.

    ========================================

    That just takes me to the download page. There is no ScriptDom file, but a further search showed me that they mean SQLDOM. So I installed SQLDOM.msi from that page above and got the following error:

    ========================================

    Microsoft SQL Server 2012 Transact-SQL-ScriptDom

    Installation of Microsoft SQL Server 2012 Transact-SQL-ScriptDom failed because a higher version already exists on the machine. To proceed, uninstall the higher version and then run Microsoft SQL Server 2012 Transact-SQL ScriptDom Setup again.

    ========================================

    Well, that was pretty confusing. First I'm told I don't have it, then I'm told I'm trying to install an older version. I've rebooted the VM and my local laptop a bunch but without assist. Microsoft Support told me they don't support upgrade advisor.

    Any assistance is much appreciated.

    Thanks

    Andre

  • July 8, 2014 at 10:05 am

    #1727821

    Found the solution on another forum:

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4691a3df-5ad1-480a-8d27-2bda7afd7078/sql-2014-upgrade-advisor?forum=sqlsetupandupgrade

    Basically, you have to have the right version of SqlDom.msi installed. I believe the upgrade advisor relies on the 32 bit version.

    Please on the following link:

    http://www.microsoft.com/en-us/download/details.aspx?id=42295

    Click on Download, then scroll down the bar with your mouse, and choose:

    ENU\x86\SqlDom.msi (32-bit)

    ENU\x64\SqlDom.msi (64-bit)

  • August 24, 2015 at 1:52 pm

    #1822090

    Thanks you very much. Install 32-bit sqlDOM resolved the SQL 2014 UA installation issue we had!

    :-):-)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply