SCENARIO
- User tries to browse to SharePoint via Dynamics 365 document files tab.
- User gets Unauthorized error
IMPACT This prevents our business users from manually uploading files into SharePoint via Dynamics 365.
TROUBLESHOOTING SO FAR
- Check other farms -> DEV/UAT farm also experiencing error, so this is not isolated to one server or trust config
- Check Power Automate/On-prem Gateway -> working as expected
- Check user permissions in SharePoint sites -> permissions configured as expected
- Check app permissions in SharePoint (appprincipals scope=site) -> looks good
- Check user profile service -> no missing profiles
- Check email format (case sensitivity) -> looks good
- Restart SharePoint WFE server -> no positive effect
- Check unbound IP whitelist -> whitelist is correct (we verified against published list of Azure IP Ranges
- Check SP Server ULS logs -> no obvious errors related to authenticated
- Check SP Server Event Log -> no auth errors
- Test with a new AD account -> no positive effect, same 401 error
- Test SharePoint integration in D365 -> configured as expected
- Check Trust configuration (Powershell) -> looks good