Exercise - Install the Microsoft Assessment and Planning Toolkit

  • 5 minutes

Suppose you're a new database administrator for a law firm with branch offices across the country/region. You're going to use the Microsoft Assessment and Planning (MAP) toolkit to create an inventory of all the SQL Server instances in the organization. First, you'll install the toolkit on a test machine and configure it to use a sample MAP database.

In this exercise, you'll install the MAP toolkit on a test computer, then restore the sample backup database.

Note

Before beginning this exercise, you must complete the Prepare for the exercises steps in the unit Decide if MAP is right for your task.

Download the RDP connection file from Azure

  1. Sign into the Azure portal using the same account with which you activated the sandbox.
  2. In the search box, search for and select Virtual Machines.
  3. In the list, select ReportingServer.
  4. On the Overview page, at the top, select Connect.
  5. In the drop-down, select RDP.
  6. Select Download RDP File, and, when it's downloaded, open the file.

Connect to the SQL Server

  1. In the Remote Desktop Connection dialog box, select Connect.
  2. In the Windows Security dialog box, select More choices, and then select Use a different account.
  3. Sign in with the username azureadmin, and the admin password you used when you created the original virtual machine. Select OK.

    Note

    You can use the echo $PASSWORD command to show you the password.

  4. In the Remote Desktop Connection dialog box, select Yes to continue.
  5. You should be logged on to the VM.

Download the Microsoft Assessment and Planning (MAP) toolkit

  1. On the VM's Start menu, select Microsoft Edge.

  2. If you're downloading MAP outside of this exercise, you'd go to https://www.microsoft.com/download/details.aspx?id=7826. However, this exercise has the following limitation:

    Important

    Due to sandbox restrictions, you need to download a backed up version of the MAP toolkit from this Git repo instead. Go to https://github.com/MicrosoftDocs/mslearn-sql-server-discovery-using-map/blob/master/MAPSetup.exe and select the Download button.

  3. Outside of this exercise, select Download on the Microsoft Assessment and Planning Toolkit page.

  4. In the pop-up, select Save.

Install the MAP toolkit

Start by using the installer to set up the MAP toolkit.

  1. Use File Explorer to go to C:\Users\azureadmin\Downloads.
  2. Double-click the MAPSetup.exe shortcut.
  3. In the Microsoft Assessment and Planning Toolkit window, select Next.
  4. On the License Agreement page, select I accept the terms in the License Agreement, and then select Next.
  5. On the Installation Folder page, leave the default location as C:\Program Files\Microsoft Assessment and Planning Toolkit, and select Next.
  6. On the Begin the installation page, select Install.
  7. The Configuring Microsoft Assessment and Planning Toolkit page displays the progress of the installation.
  8. On the Completed the Setup Wizard for Microsoft Assessment and Planning Toolkit page, select Finish.

Download the sample MAP database

  1. Use Microsoft Edge to go to https://github.com/MicrosoftDocs/mslearn-sql-server-discovery-using-map/blob/master/MAP_updatedDB.bak.
  2. Select Download.

Connect to the sample MAP database

Now that MAP is installed, you can use it to analyze a database. Follow these steps:

  1. On the Start menu, select Microsoft Assessment and Planning Toolkit.
  2. The toolkit opens. If the Microsoft Assessment and Planning Toolkit dialog box doesn't automatically open, on the File menu, select Create/Select Database.
  3. In the Microsoft Assessment and Planning Toolkit dialog box, select Manage.
  4. In the Microsoft Assessment and Planning Toolkit dialog box, select Import.
  5. In the Microsoft Assessment and Planning Toolkit dialog box, next to Backup File, select Browse.
  6. In the Microsoft Assessment and Planning Toolkit dialog box, go to C:\Users\azureadmin\Downloads, select the MAP_updatedDB.bak file, and then select Open.
  7. In the Microsoft Assessment and Planning Toolkit dialog box, in the Database Name box, type MapTrainingDatabase, and then select OK.
  8. In the Microsoft Assessment and Planning Toolkit dialog box, note the Successfully imported the database. Database name: MapTrainingDatabase message, and then select OK.
  9. In the Microsoft Assessment and Planning Toolkit dialog box, select Close.
  10. In the Microsoft Assessment and Planning Toolkit dialog box, select Use an existing database, select MapTrainingDatabase, and then select OK.