Search code examples
filexp-cmdshell

I am getting file not found on xp_cmdshell dir on local directory

Here is what I am trying to execute:

exec xp_cmdshell 'dir "D:\Data\GS Products" /AD /S /B'

This works with every other folder on data that I have tried but not with the one I am trying to use. I am logged in with the admin god privs, I have done the sp_configure to enable cmdshell and I have used this with other folders that have spaces in the name. Is it permissions? And if so, how can I check that? When I look at the properties of the folder it says the admin account has FULL permissions. Any help would be greatly appreciated.

Solution

  • Well, didnt get much help this time, but maybe I did it wrong..anyway, I had to add the SQL Service account pemissions to the folder I was doing the command on. Even though I was logged in with the top admin login, it did not work until I added the permissions to the folder/subfolders.