SQLServer 2017 exec xp_cmdshell 'dir Y:\*.*/s' command fails

[AmjiBhai]

Humble Greetings to All,

I executed the following command successfully
exec xp_cmdshell 'dir D:\*.*/s'

But this command failed when I made the following amendment
exec xp_cmdshell 'dir Y:\*.*/s'

Y: Drive is a network drive (Mapped) to which I am connected.
The error Message says:
The system cannot find the path specified.

Please Help!

 

[Ian]

If you're in the command prompt, can you interact with the mapped drive as you would expect? Does something as simple as "y:" let you access the mapped drive there?

I've occasionally seen it where I can access a mapped drive in explorer, but not from the command prompt. I'd be interested to see if that's possible as a regular user and in an elevated admin command prompt. It might gives some clues as to where the problem is.

 

[AmjiBhai]

Thank you Ian, I checked and as you can see the dos prompt Y:> is successful but SQL Server System cannot find the specified path.
I think I must be missing some (granting) commands which allows exec xp_cmdshell reach a mapped network drive.

 

[Ian]

Is there a way to test running exec xp_cmdshell with admin level permissions to see if that helps?

I wonder if ProcMon would should any permission errors (https://docs.microsoft.com/en-us/sysinternals/downloads/procmon) when this command runs.