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's gravatar image

Serge
12681016
accept rate: 0%

edited 29 Nov '12, 06:15

Volker%20Barth's gravatar image

Volker Barth
40.1k361549819


The mapping for NET USE always requires a Windows User Account to access the resource. This is (generally) not the same as the Database User (which is used to log in to the database). Mapped drives are available to the Windows user that created them.

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 "NET USE /USER:" command, you are telling Windows which network credentials to use when accessing the network.

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).

permanent link

answered 28 Nov '12, 17:01

Jeff%20Albion's gravatar image

Jeff Albion
10.8k171175
accept rate: 25%

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.

permanent link

answered 29 Nov '12, 10:49

Serge's gravatar image

Serge
12681016
accept rate: 0%

edited 29 Nov '12, 10:51

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×8

question asked: 28 Nov '12, 14:15

question was seen: 4,034 times

last updated: 29 Nov '12, 10:51