MAPS (Microsoft Assessment and Planning Toolkit) not producing reports

Derrick IBM 1 Reputation point
2021-01-18T21:35:53.793+00:00

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

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
570 questions
{count} votes

2 answers

Sort by: Most helpful
  1. AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
    2021-01-19T03:11:24.54+00:00

    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.

    57905-03.jpg

    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.

    0 comments No comments

  2. Francesco Mantovani 1 Reputation point
    2021-05-03T11:14:14.807+00:00

    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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.