xp_cmdshell resulted in "access is denied"

[Ly]

Scenario:
----------

SQL server: 192.168.1.3
Server 2: 192.168.1.2, a folder named ABC is shared out.

Both servers have the same password for the account named
"Administrator"

----------
i tried to execute the following command in SQL server (192.168.1.3):

exec master..xp_cmdshell 'move /Y "D:\test.txt"
"\\192.168.1.2\ABC\test.txt"'

and got the error "access is denied"

However, when i execute the move command in the command prompt of the
SQL server, there was no problem. i'm able to connect to
\\192.168.1.2\ABC without any problem too.

What could be the problem?

[Erland Sommarskog]

Ly (fe***********@yahoo.com) writes:

SQL server: 192.168.1.3
Server 2: 192.168.1.2, a folder named ABC is shared out.

Both servers have the same password for the account named
"Administrator"

----------
i tried to execute the following command in SQL server (192.168.1.3):

exec master..xp_cmdshell 'move /Y "D:\test.txt"
"\\192.168.1.2\ABC\test.txt"'

and got the error "access is denied"

However, when i execute the move command in the command prompt of the
SQL server, there was no problem. i'm able to connect to
\\192.168.1.2\ABC without any problem too.

What could be the problem?

Under which account is SQL Server running under? You can check this
in the Service applet in Computer Manager.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp