Posts about SQL Server 2012 Upgrade Advisor on SQL Server Portal
SQL Server upgrade advisor is one of the important tools and it plays a pivotal role when you need to assess the upgrade in your SQL Server. However, I got an error message when installing SQL Server 2012 upgrade advisor. Given below is the screen image of the error message.
Let me explain the error and its solution in detail.
Error Message: Setup is missing prerequisites: -Microsoft SQL Server 2012 Transact-SQL ScriptDom, which is not installed by Upgrade Advisor Setup. To continue, install SQL Server 2012 Transact-SQL ScriptDom from below hyperlink and then run the Upgrdae Advisor Setup operation
Go to http://go.microsoft.com/fwlink/?linkID=216742
It seems that it is not only the error message but also the solution as well. Let me resolve it step by step.
Step 1 :
First of all, you need to go to the URL as mentioned
above in order to fix this bug.
Step 2 :
Once you browse the above link, it will take you to a page where you need to download the instruction to proceed further. However, you can select theInstall instructionlink shown below to get the list of all SQL Server tools.
Step 3 :
Once you browseinstall instruction , you need to scroll down till you will find Microsoft® SQL Server® 2012 Transact-SQL ScriptDom. It is available for both (x86 & x64) system types as shown below. However make sure the system type of your server before downloading it. Its installation is self explanatory. Once you install it, you can easily install SQL Server 2012 upgrade advisor.
Read Full Post »