问题描述
这是我要执行的操作:
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目录上找不到文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！