MAPS (Microsoft Assessment and Planning Toolkit) not producing reports

Question

Hi,

I am running MAPS (Microsoft Assessment and Planning Toolkit) to produce an inventory of all SQL Servers, SQL databases and Oracle servers.

The tool runs successfully and when I click on the database tab I have the option to produce the two SQL Server reports. I click on the links to generate the reports but neither is produced in the location when I open it.

I have run this tool successfully at many other clients and the reports have always been produced. Any idea why they are not being produced in this case? I thought it could have been due to permissions on my Documents folder but I set them to everyone and it still didn't work.

Also, is there a way to run the Toolkit against multiple domains as we are in the process if changing domains and I want to run it against all the older domains as not all the SQL Servers have been moved to the new domain yet.

Thanks

Derrick

Answer 1

Hi @Derrick IBM ,

Any idea why they are not being produced in this case?

Please use an Administrator user account while running the MAP Toolkit. By default, MAP reports are saved in C:\Users\<current user profile>\Documents\MAP\<Database Name>.
You can also access them in the menu View -> Saved Reports… which will open the correct folder for the currently selected database.

is there a way to run the Toolkit against multiple domains?

MAP can gather inventory information from machines on any domain as long as the appropriate administrator credentials are provided to the MAP wizard. The machine upon which MAP is running does not have to be a member of the target domain or forest.
And MAP can gather performance data from multiple domains as long as the appropriate administrator credentials are provided to the MAP wizard and the MAP machine is a member of the same forest as the target machines.
Please refer to this article which might help.
Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I found the solution Derrick, I can confirm you MAP Toolkit still works on 05/2021.

If you want to scan your network to find SQL Server instances:

• Use AD login
• Always use DOMAIN\username because without the DOMAIN\ the user only won't work
• When you are under All Computer Credentials > Edit, and here tick SQL Native. you need to have all the 3: WMI, SQL Windows and SQL Native

Now run the scan