I have this running on three other machines right now, so I just cannot figure out what the heck i'm missing
DECLARE @fileExists INT
EXEC master.dbo.xp_fileexists '\\server\share\file.csv', @fileexists OUTPUT
Run it as my login (admin), i get the 1 back I am looking for. (the file exists)
Run it as the app login, i get back 0. It cannot see the file.
xp_cmdshell is enabled
proxy account is the account the service runs under, admin to the local box, that's where the share is
login has appropriate permissions. no error is returned, i just get zero, it can't see that share using that login/user
what did I miss?