我在本地目录的xp_cmdshell目录上找不到文件 [英] I am getting file not found on xp_cmdshell dir on local directory

问题描述

这是我要执行的操作:

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

这与我尝试过的数据上的其他所有文件夹一起使用，但不适用于我要使用的数据.我使用admin God privs登录，已完成sp_configure启用cmdshell，并且已将其用于名称中带有空格的其他文件夹.是权限吗?如果是这样，我该如何检查?当我查看文件夹的属性时，它说管理员帐户具有FULL权限.任何帮助将不胜感激.

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.

推荐答案

好，这次没有得到太多帮助，但是也许我做错了.执行命令.即使我使用顶级管理员登录名登录，但直到我将权限添加到文件夹/子文件夹后，它才起作用.

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.

这篇关于我在本地目录的xp_cmdshell目录上找不到文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！