question

DerrickIBM-4651 avatar image
0 Votes"
DerrickIBM-4651 asked FrancescoMantovani-8046 answered

MAPS (Microsoft Assessment and Planning Toolkit) not producing reports

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
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DerrickIBM-4651,

Did the answer help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 Votes 0 ·

Hi Amelia,

Yes, I found the reports in the documents folder of the Admin user that I ran MAPS with. Thanks.

Now I want to run it against all our domains but I can't seem to find out how to do that, can you assist me with setting up MAPS to inventory other domains?

Thanks
Derrick

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @DerrickIBM-4651,

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.



03.jpg (73.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

FrancescoMantovani-8046 avatar image
0 Votes"
FrancescoMantovani-8046 answered

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




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.