In Volker Barth's answer to question "How do I execute a batch file using xp_cmdshell" he suggests to do:
xp_cmdshell("NET USE /USER:.......") -- do the desired network access xp_cmdshell("NET USE /DELETE ....")
In this case we have mapped network volume to local /letter/: and user with needing rights. I can`t understand one thing, how it influence on server but it steel on local account. And current user of dbeng12.exe is not the same in "NET USE /USER:.......".
Thanks for explanations.
The mapping for
What I'm assuming about the above description is that you have a database server running as a system service, underneath the LOCAL SYSTEM account and would like access to network resources. By default, the LOCAL SYSTEM account does not have access to network permissions - by using the
Another solution to this issue would be to run the database service underneath the user account that has already set up the mapped network permission (instead of underneath the LOCAL SYSTEM account).
answered 28 Nov '12, 17:01