April 18, 2012 at 6:45 am
Running into an issue. I have a stored proc that's trying to bulk load a data file that's located on another server. SQL Server Agent is running under a domain account corporate\sqladmin for example.
When the proc runs, I get the error that it can't access the data file on the other server. I have added the domain account to the folder where it's trying to access the file.
i'm not sure what else to try.... any help would be appreciated.
John
April 18, 2012 at 9:32 am
jchappell 92664 (4/18/2012)
Running into an issue. I have a stored proc that's trying to bulk load a data file that's located on another server. SQL Server Agent is running under a domain account corporate\sqladmin for example.
Who is the job owner?
edit: and are they a sysadmin?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 18, 2012 at 9:38 am
Also to check - is the file referenced by UNC path?
And by network or admin share?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply