Migration Assistant Access 2003 to SQL Server 2008 R2 license file RRS feed

  • Question

  • After an unsuccessful attempt to upsize Access 2003 to SQL Server 2008 R2 I am now trying to install the Microsoft SQL Server Migration Assistant for Access properly.

    The first part of the install asked to install Access 2010 redistributable components (either a 32 or 64 bit version) but I skipped this as I have Access 2003 installed.

    Now I tried to install the access-ssma.license file but it won't open as Windows File Association doesn't recognise the file.

    My operating system is Win 7 HP 64-bit.

    Any ideas?

    Sunday, March 4, 2012 2:40 PM


All replies

  • You don't need to open it, all you need to do is:

    1. Download the license key on this page to your hard
    2. Place the license key file into SSMA installation directory
      (by default, C:\Program Files\Microsoft SQL Server Migration Assistant) and
    3. Click Refresh License in SQL Server Migration Assistant.


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    • Proposed as answer by tooleyrose Monday, March 5, 2012 4:08 AM
    • Marked as answer by meridius10 Monday, March 5, 2012 10:56 AM
    Monday, March 5, 2012 3:37 AM
  • Thanks.

    I copied the file access-ssma.license into C:\Microsoft SQL Server Migration Assistant for Access, refreshed and it is now working.

    Monday, March 5, 2012 10:56 AM