xp_cmdshell problem

[seekwall]

I am using SQL Server 2000, and am trying to run the following command:

execute master..xp_cmdshell 'dir g:\'

The 'g' drive on the SQL Server points to a server at a co-location via a VPN.

When I run the above commmand, I get the following error message:

output -----------------------------------------------------------Logon failure: unknown user name or bad password.
NULL

Security isn't my strong point, so could anyone shed some light on this problem for me ?

 

[JamesLean]

When you execute xp_cmdshell, it executes in the security context of the SQL Service account. You need to make sure this account has the necessary privelages on the network drive.

--James