Ok...

If I run the batch when I'm logged into the server, it works fine. I'm assuming it is using my credentials to access the network location.

As you can see from...

That is the code I'm using. In the SQL job's step, I have the following code:

exec xp_cmdshell "d:\sqlcode\runsql.bat"

The .bat file code is the following:

sqlcmd -S ECOM-VS-01 -i "d:\sqlcode\backorder.sql" -o...

Since the account that SQL Agent is a member of a group that has write access to the network location, the SQL job should be able to write to the...

My account, ECOMSA01, is member of Domain Users.

Domain Users has write-access to this network location.

Am I missing something?

I am unable to copy to the \\temp-shed-40 location either as a mapped drive or direct connection as a different domain user.

D: is a local drive to the SQL server...

I'm not very familiar with Active Directory.

SQL Server is running under a domain account on the network. This account should have access to network resources.

How can I be sure?

Jason