Here is what you will run into. Mapped drives are created by login scripts or batch files. Neither of which apply to SQL Server on server as it runs as a service, not a logged in user.

If you go out to a spawned command line and map the drive, it will be visible to that spwned process, but not to SQL Server.