Troubleshoot - SPMT - You must be a site collection administrator ...
Synopsis: SharePoint Migration tool is failing in bulk during csv import with an error message
Published June 16th, 2026
Last Modified: June 16th, 2026
Issue Symptons:"You must be a site collection administrator in the destination to perform this task"

Published June 16th, 2026
Last Modified: June 16th, 2026
Issue Symptons:

Troubleshooting Sections
-
1.) Solution: Sign in method
2.) Other: Reboot
3.) Other: Assign Site Collection Admin in Bulk via PowerShell script
Sign in Method
-
Changing the sign in method from 'No, this app only', to 'Yes' solved this issue during my testing.

Reboot
-
Rebooting the server that was running the SharePoint Migration Tool had no impact on the error message.
Update permissions
-
I have come accross SPO environments with unexplainable, yet broken permissions. My first instinct here was to correct them in bulk via powershell.
- GitHub Script
I have created a script here that can assign the admin as a site collection administrator to each respective site. As noted above, this was not required but will be helpful in the future I'm sure.