SQL Server 2014 Upgrade Advisor failing

Question

I've installed SQL Server 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 :

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.

Answer 1

Go to the Microsoft® SQL Server® 2014 Feature Pack page, here:

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

Click the Download button, then look for the download named "SqlDom.msi"; the x64 version is about 1/3 of the way down, the x86 version is about 80-85% of the way down.

These should be the latest versions of the ScriptDom.

Answer 2

I had the same issue, installed x64 sqldom.msi - it didn't work. So I then installed x86 version and the upgrade advisor worked. This was on server 2012R2 with SQL2012 x64.