如何在sql server 2008中通过XP_CMDSHELL通过网络访问文件/文件夹? [英] how can i access a file/folder over network through XP_CMDSHELL in sql server 2008?

问题描述

我正在尝试使用'EXEC MASTER..XP_CMDSHELL'访问文件夹/目录，它适用于本地文件/文件夹，但是它无法通过网络访问该文件夹.

I am trying to access a folder/directory using 'EXEC MASTER..XP_CMDSHELL' it works for the local file/folder, how ever it can not access the folder over network.

EXEC MASTER..XP_CMDSHELL 'c:\Images'  --Works fine
EXEC MASTER..XP_CMDSHELL '\\IPaddress\Images' -- returns "Access is denied."

请注意，我可以访问网络位置，但不能使用sql server.

Please note that i can access the network location but not using sql server.

Sql服务器正在Winodws身份验证模式下运行. SQL服务器正在使用"NT Authority \ Network Service"帐户访问远程文件夹.

Sql server is running under Winodws Authentication mode. Sql server is using 'nt authority\network service' account to access the remote Folder.

致谢

推荐答案

如果运行xp_cmdshell'whoami.exe'，它将告诉您该命令在其下运行的帐户.如果此帐户没有网络权限，则会收到您看到的错误.

If you run xp_cmdshell 'whoami.exe' it will tell you the account the command is running under. If this account doesn't have permissions on the network, you'll get the error you are seeing.

检查SQL文档以更改此帐户/权限.

Check the SQL documentation for changing this account/permissions.

这篇关于如何在sql server 2008中通过XP_CMDSHELL通过网络访问文件/文件夹?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！