MAP Toolkit: Installation

  • Article

Return to the MAP Toolkit Getting Started Guide

Install the MAP Toolkit on a single computer that has access to the network on which you want to conduct an inventory and assessment. The toolkit uses a SQL Server database to store and process the information that it collects from your environment.  There are two options for your database installation:

Database Option

When to use

LocalDB
  • Most of the time.  This is the default option, when the MAPS instance does not already exist
  • Databases will be less than 10 GB

MAPS Instance
  • You have an existing MAP database that you want to preserve
  • Your database will grow more than 10GB
  • Multiple users need to connect to the MAPS database

LocalDB provides several benefits:

  • Faster installation of the MAP Toolkit
  • Internet access is not needed during install of the MAP Toolkit
  • Computer resources to support SQL Server are not utilized when MAP is not running

How to Install MAP Using LocalDB

The Microsoft Assessment and Planning Toolkit Setup Wizard will guide you through the installation of application files and Microsoft SQL Server 2012® Express LocalDB.

  1. After you run the MAP Setup, the Welcome screen will display. Click Next to continue.
  2. Read and accept the License Agreement and then click Next to continue.
  3. Select where to install MAP (generally you can accept the default) and click next to continue.
  4. Review the Customer Experience Improvement* Options and then click Next.
  5. The MAP Toolkit will now install LocalDB and the MAP Toolkit files. Since the LocalDB installation is much smaller and quicker than SQL Server Express, the MAP Toolkit Setup will complete quicker than previous versions.
  6. After successful installation the MAPS installer will offer to reboot your computer. You can delay the restart to a more convenient time and then resume your MAPS collection.

*For more information about Microsoft Customer Experience Improvement Program (CEIP), go to http://go.microsoft.com/fwlink/?LinkId=229285.

How to install MAP using your own SQL Server

By default, the MAP Toolkit will install Microsoft SQL Server 2012® Express LocalDB during setup. You may also use an existing installation of SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 but you must create a non-default instance named “MAPS” before running the MAP Toolkit installer. The MAP Toolkit requires the collation order of the database engine to be set to “SQL_Latin1_General_CP1_CI_AS”.

This instance is customized for the MAP Toolkit and should not be modified. By default, access to this instance is blocked from remote computers. Access to the instance on the local computer is only enabled for users who have local administrator credentials.

Troubleshooting installation issues

If you encounter a problem during installation, refer to the installation log files. The log files are located in the path specified in the %TEMP% environment variable on the local computer. You can find additional troubleshooting information by examining the application and system event logs.

Prerequisites not found: MAPS instance

If you have a SQL Server instance called MAPS on your computer and it is SQL Server 2005, you will receive a Prerequisites Not Found: MAPS Instance during installation. If you receive this error message, you need to do one of the following:

  • Uninstall the instance

Upgrade to SQL Server 2008 or higher

Return to the MAP Toolkit Getting Started Guide