none
Migration Assistant Access 2003 to SQL Server 2008 R2 license file

    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 04, 2012 2:40 PM

Answers

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
      disk.
    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.

    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=18589


    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 05, 2012 4:08 AM
    • Marked as answer by meridius10 Monday, March 05, 2012 10:56 AM
    Monday, March 05, 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 05, 2012 10:56 AM