Since the windows account you are trying to use does not resolve on the PI Data Archive, likely the domains are not trusted. I would check out KB00354 for more information regarding domain architectures and leveraging WIS. It looks like using Windows Credential Manager, local accounts, or even configuring a trust for the client machine would likely be the simplest options. This is simply a limitation of Windows Integrated Security between untrusted domains.
As Adam Fink said, mapping can be troublesome when used in workgroup environment and/or cross-domain cases. In the case, local user accounts should be created in server node and clients can utilize the server's user accounts instead of its own.
The process is very similar to Example 2 in KB01457 - Using Windows Credential Manager with PI Applications.