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. asked 28 Nov '12, 14:15 Serge Volker Barth |
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 Jeff Albion Thanks a lot, now left only try to use this approach.
(29 Nov '12, 06:00)
Serge
|
The best way make dbsrv12 transferring files through network is using READ_CLIENT_FILE() and WRITE_CLIENT_FILE() but there is one fault WRITE_CLIENT_FILE() can't create directories even when all rights given. answered 29 Nov '12, 10:49 Serge |