1

Topic: To get access to server files through Microsoft SQL server 2008R2

Prompt ))
The question in the following for example is a computer "And" with sql the server on it where  in Moscow, and there is a computer "B" with   on it where a thread in Sochi, at server "A" is exterior IP with open port to which there is an access under administrator SA.
Whether it is possible to get from computer "B" access to files on disks of computer "A" and what that image them to copy on a computer "B"?
Simply when you do  bases through management  for example, the explorer with folders and files opens when specify a saving way , but there is no possibility as that to use files on remote computer "And" probably there is a method as that to be connected to a computer "A" like a file mode of a data interchange without physical presence about a computer "And"?
For example made , and then it far off copied to itself on a computer?
vivery\ammi\radminy are not considered))

2

Re: To get access to server files through Microsoft SQL server 2008R2

HeLDeR wrote:

it is simple when you do  bases through management  for example, the explorer with folders and files opens when specify a saving way , but there is no possibility as that to use files on remote computer "And"

There is a possibility, simply specify a network way.

HeLDeR wrote:

For example made , and then it far off copied to itself on a computer?

Yes, it is possible to copy  from the server on other computer any command of copying.

3

Re: To get access to server files through Microsoft SQL server 2008R2

alexeyvg wrote:

it is passed...
There is a possibility, simply specify a network way.
it is passed...
Yes, it is possible to copy  from the server on other computer any command of copying.

If at the sufferer access to MS SQL -

 is opened only
OPENROWSET (..., SINGLE_BLOB)

.

4

Re: To get access to server files through Microsoft SQL server 2008R2

Whether

HeLDeR wrote:

It is possible to get from computer "B" access to files on disks of computer "A" and what that image them to copy on a computer "B"?

Remote access to files it not the task " ".
It just the task - "Tim vivery\ammi\radminy"

HeLDeR wrote:

For example made , and then it far off copied to itself on a computer?

Made . Better a script, instead of pens through the interface.
Archived, copied archive on FTP
And then anywhere with FTP copy.
All process is easily automated.