Re: list contents of document library via unc path from xp_cmdshell

Tech-Archive recommends: Fix windows errors by optimizing your registry

{\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\lang2052\f0\fs20 Hello,
\par
\par Thank you for the update.
\par
\par xp_cmdshell use the SQL Server service account to execute the command. However, when it is called by a user that is not a member of the sysadmin fixed server role, xp_cmdshell connects to Windows by using the account name and password stored in the credential named ##xp_cmdshell_proxy_account##. If this proxy credential does not exist, xp_cmdshell will fail. You may continue to check this.
\par
\par BTW, when executing 'net use X: "http://<wss server iis host header name>/Shared Documents" /user:<domain>\\<username> <password>'
\par
\par Is the user your cuurent log user or SQL Server service account user? If you enable "anonymous access" on the wss site, will it work?
\par
\par
\par Luke Zhang
\par Microsoft Online Community Lead
\par
\par ==================================================
\par When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue.
\par ==================================================
\par
\par (This posting is provided "AS IS", with no warranties, and confers no rights.)
\par
\par }

Relevant Pages