Hi Ben,
I'm Sumit, here to assist with your question.
Apologies for any inconvenience - I'm happy to help you today.
This is a very common nuisance with Windows. You would have to update your password of the destination computer's Microsoft account from Windows itself and it should start working.
Also, please run the commands given in this article as well which should help a lot:
https://www.yourwindowsguide.com/2025/01/mapped-drives-24h2.html
I look forward to your response and am eager to collaborate until we find a solution.
A Windows MVP writes content on the above website, so it is safe. However, do watch out for the ads. It should translate into your Browser language automatically.