Wednesday, May 9, 2012

Installing SQL Server 2012 Upgrade Advisor

We're hot and heavy into upgrading our BI environment from SQL Server 2008 R2 to 2012 and plan to go live around the middle of next month. To that end, I am in the process of running the SQL Server 2012 Upgrade Advisor on copies of our production servers. Before we can run it, however, we have to get it installed. That turned out to be a little on the obtuse side.


Finding the installer was pretty easy, it's right in the SQL Server Installation Center:




If you're not prepared, however, you'll get the following error message when you try to use the installer:
Setup is missing prerequisites: Microsoft SQL Server 2012 Transact-SQL ScriptDom, which is not installed by Microsoft Advisor Setup. To continue, install SQL Server 2012 Transact-SQL ScriptDim from the below hyperlink and then run the Upgrade Advisor Setup operation again: Go to http://go.microsoft.com/fwlink/?LinkID=216742
That link doesn't work and isn't even clickable! Not only that, but finding the installer you need may not completely solve the problem.

To make a long blog post a little bit shorter, here's what you need before you can install the SQL Server 2012 Upgrade Advisor (in order):
  1. Microsoft .NET Framework 4.0 (I recommend the full installer and not the web-based thing. Download it from http://www.microsoft.com/en-us/download/details.aspx?id=17718)
  2. SQL Server 2012 Transact-SQL ScriptDom (Go to the Microsoft® SQL Server® 2012 Feature Pack page and you'll find it about 3/4 of the way down the page)
  3. Once you have the .NET Framework and the ScriptDom installed you can install and use the Upgrade Advisor
Happy Upgrading!

7 comments:

  1. Thank you, this was very helpful!

    ReplyDelete
  2. Very Informative Post on MSBI.Good Job

    ReplyDelete
  3. As a faculty i liked ur post.it will be helpful for me also.
    rozeena




    rozeena

    ReplyDelete
  4. Hi Bryant.
    Even after doing the suggestions, I still received the ScriptDom not installed error window. The same installation programs run fine on a Windows 7 box, the Advisor even runs. But on a Sql Server 2008 box, the ScriptDom error is displayed?
    Mike

    ReplyDelete
    Replies
    1. Hi Mike,

      Did you install the right "bitness" (32 or 64) for your server? It's been a while since I ran into this and I don't remember if it's supposed to match the server or whatever client tools your trying to use. I don't remember if a reboot was required either.

      I'm sorry that I don't have more help to give you. I thought it had been a long time since I posted this and when I looked the top I realized that it will be two years tomorrow since the original post. If you figure it out, please post a comment or link to the solution in case someone else runs into the same issue.

      Thanks for stopping by!
      Bryant

      Delete
  5. It worked for me...
    ScriptDom will be located at
    MICROSOFT SQL SERVER 2012 ENGINE FEATURE PACK COMPONENTS


    Microsoft® SQL Server® 2012 Transact-SQL ScriptDom
    Microsoft SQL Server Transact-SQL ScriptDom is a .NET Framework API that provides parsing and scripting services for Transact-SQL. This API supports SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012 versions.

    X86 Package(SQLDOM.MSI)
    X64 Package (SQLDOM.MSI)

    ReplyDelete
    Replies
    1. Thanks for the extra information Madhu!

      Delete