I've got a problem. I have a novell file server and a NT4 workstation SP6a. I want the workstation to copy data from the novell server every hour or so. The novell administrator made a share for me, and I made a drive mapping to this share.
Next I created a batch file to copy the files needed:
echo y | del c:\database
copy h:\*.* c:\database
If I execute this batch file, it runs perfectly. However, if I schedule it, or I have SQL server run it, I get an 'Access is denied' error.
The same problem occurs not only with the batch above, but also when I try 'dir h:\', so the problem is really related to the share
I use an administrative account called 'tourweb', and I have the task scheduler, the MSSQL Server and the MSSQL Agent run under this account.
I prefer to have SQL Server run these commands using the xp_cmdshell proc for example (lets the MSSQL Agent run a dos command under its account), because then I can insert these commands in an existing job.
To troubleshoot I was thinking about a commandline utility or a VB program to write the user context to a file, but I don't have a command line utility, nor the code for VB.
This problem is now the bottleneck in my project, because I have to run the batchfile above several times a day manually. Does anyone have any idea!?
I assume the 'standard' netware client is installed, but I'm a newbie to netware. Have a look at the following screenshot: