The MAP toolkit is used for multi-product assessment and planning. It accessed a network environment using agentless data collection technologies to gather inventory and performance information. Then provides assessment reports and executive proposals with recommendations to aid organizations with their IT infrastructure planning.
(Source: The MAP Toolkit Survival Guide)
By default, MAP Toolkit connects to the localDB, SQL Express 2012. To connect to other version SQL, we need to install the SQL Server manually and change the instance name to "MAPS".
MAP Toolkit supports any edition of SQL Server 2008, 2008 R2 and 2012 but the SQL server and MAPS Toolkit must be installed in the same server.
MAP Toolkit supports the following operating system:
- Windows 7 Professional, Enterprise and Ultimate with Service Pack 1
- Windows Vista Business, Enterprise and Ultimate with Service Pack 2
- Windows Server 2008 all edition with Service Pack 2
- Windows Server 2008 R2 all edition with Service Pack 1
- Windows Server 2012 all edition
I will install SQL server and MAPS in a server, MP01 which was installed Windows Server 2008 R2 with Service Pack 1.
Assuming that Microsoft .Net Framework 3.5 and Microsoft .Net Framework 4.0 with update 2 have been installed in MP01.
Installing SQL Server
1. On MP01, log in as Domain Administrator.
2. Insert SQL Server 2012 standard DVD.
3. Click "Run SETUP.EXE".
4. On "SQL Server Installation Center", click "Installation > New SQL Server stand-alone installation or add features to an existing installation".
5. On "Setup Support Rules" window, click "OK".
6. On "Product Key" window, click "Next".
7. On "License Terms" window, check "I accept the license terms".
8. Click "Next".
9. On "Setup Support Rules" window, click "Next".
10. On "Setup Role" window, select "SQL Server Feature Installation", click "Next".
11. On "Feature Selection" window, check "Database Engine Services", "Management Tools - Basic" and "Management Tools -Complete".
12. Click "Next".
13. On "Installation Rules" window, click "Next".
14. On "Instance Configuration" window, select "Named instance", type "MAPS".
Remark: Make sure the "Named instance" is changed to "MAPS". If the instance name isn't changed, MAP Toolkit cannot connect to this SQL server.
15. Click "Next" twice .
16. On "Server Configuration" window, provide the user name and password for "SQL Server Agent" and "SQL Server Database Engine".
17. Select "Collation" tab, make sure "Database Engine" is "SQL_Latin1_General_CP1_CI_AS".
18. Click "Next".
19. On "Database Engine Configuration" window, click "Add Current User" and then click "Next".
20. On "Error Reporting" window, click "Next" twice.
21. On "Ready to Install" window, click "Install".
22. On "Complete" window, click "Close"
Installing Microsoft Assessment and Planning (MAP)
1. On MP01, log in as Domain Administrator.
2. Run "Microsoft_Assessment_and_Planning_Toolkit_Setup.exe".
3. On "Welcome to the Microsoft Assessment and Planning Toolkit Setup Wizard", click "Next".
4. On "License Agreement" window, select "I accept the terms of the license agreement".
5. Click "Next".
6. On "Installation Folder" window, click "Next".
7. On "Customer Experience Improvement Program" window, select "I don't want to join the program at this time".
8. Click "Next".
9. On "Ready to Install" window, click "Install".
10. On "Installation Successful" window, click "Finish".
11. Now, the "Data source" is selected the "MAPS Instance".
12. Next to "Name", type "MAP Test", click "OK".
13. Launch "Microsoft SQL Server Management Studio".
14. Click "Connect".
15. Expand "Databases".
The "MAP Test" was created in the SQL Server.
Remark: The localDB was installed when you install MAP Toolkit.
Download link:
This posting is provided “AS IS” with no warranties, and confers no rights!
No comments:
Post a Comment