Bulk insert from file share

Hi - I'm trying to run a bulk insert from a file that exists on a
network share, but I'm getting the error "Could not bulk insert
because file '\\server\tester.txt' could not be opened. Operating
system error code 5(Access is denied.)".
I'm running the bulk insert command from Management Studio on the SQL
server console. The SQL server and the file server are both members
of the same domain. I'm logged in with a domain account that is in
the Administrators group on both machines. The SQL Server service is
also using a domain account that is in the Administrators group on
both machines. I can access the share and the file through Explorer
with no problem, and the same is true if I log in manually with the
SQL Server service account.
There's no reason why I should be getting the access denied message,
regardless of which account it's using. I can't find anything on the
Microsoft's site, but plenty of other people have complained about the
same symptom, and this sure feels like a bug. Am I missing something?
Thanks, S.On Oct 19, 2:47 pm, stavros <stav...@.mailinator.com> wrote:
> Hi - I'm trying to run a bulk insert from a file that exists on a
> network share, but I'm getting the error "Could not bulk insert
> because file '\\server\tester.txt' could not be opened. Operating
> system error code 5(Access is denied.)".
> I'm running the bulk insert command from Management Studio on the SQL
> server console. The SQL server and the file server are both members
> of the same domain. I'm logged in with a domain account that is in
> the Administrators group on both machines. The SQL Server service is
> also using a domain account that is in the Administrators group on
> both machines. I can access the share and the file through Explorer
> with no problem, and the same is true if I log in manually with the
> SQL Server service account.
> There's no reason why I should be getting the access denied message,
> regardless of which account it's using. I can't find anything on the
> Microsoft's site, but plenty of other people have complained about the
> same symptom, and this sure feels like a bug. Am I missing something?
> Thanks, S.
That will teach me to post late on a Friday. Refreshing the thread
here, anyone have info on this?|||I'm having exactly the same problem.
I have looked around and found that i apparently needed SQL to allow remote
connections via TCP\IP - which i've granted.
I've also granted "everyone" full control on the file i'm trying to access.
and still it doesn't work
I have two steps in a sql job... first is bulk insert the file - second is
move the file with a vbscript... the second step works fine, but bulk insert
fails.
dont' know what the problem is...
"stavros" wrote:
> On Oct 19, 2:47 pm, stavros <stav...@.mailinator.com> wrote:
> > Hi - I'm trying to run a bulk insert from a file that exists on a
> > network share, but I'm getting the error "Could not bulk insert
> > because file '\\server\tester.txt' could not be opened. Operating
> > system error code 5(Access is denied.)".
> >
> > I'm running the bulk insert command from Management Studio on the SQL
> > server console. The SQL server and the file server are both members
> > of the same domain. I'm logged in with a domain account that is in
> > the Administrators group on both machines. The SQL Server service is
> > also using a domain account that is in the Administrators group on
> > both machines. I can access the share and the file through Explorer
> > with no problem, and the same is true if I log in manually with the
> > SQL Server service account.
> >
> > There's no reason why I should be getting the access denied message,
> > regardless of which account it's using. I can't find anything on the
> > Microsoft's site, but plenty of other people have complained about the
> > same symptom, and this sure feels like a bug. Am I missing something?
> >
> > Thanks, S.
> That will teach me to post late on a Friday. Refreshing the thread
> here, anyone have info on this?
>