you can create a virtual drive from \\server2 and try to access the file
thru a virtual drive

[quoted text, click to view]
\\server2\test\test.txt' I get an error saying no permission to the network
drive. Is there a way to specify the user and password here? Thanks

In message <21D32955-43DC-403E-A5C4-5F683818766D@microsoft.com>,
anonymus <anonymous@discussions.microsoft.com> writes
[quoted text, click to view]

Have a read of the Books Online topic for xp_cmdshell to determine which
account is being used for the security context. Most likely it is the
SQL Server service account, so make sure this is not localsystem, and
also has access to the server\share required.

It is possible to setup a unc path connection through xp_cmdshell, with
the net use command, and this allows you to supply a username and
password. There is no need to use a drive letter and I would avoid it to
prevent coding something that may latter clash. Just use the UNC path at
all times, including it the disconnect (/DELETE).

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org