Bulk Insert

I cannot bulk insert a file from a network drive. Getting
an error that access is denied. However, if I run the
file name from the start menu it will open the file just
fine or if I run the bulk insert from the local drive of
the server it runs fine.
The directory on the network is everyone full control.
Any idea's?Check the account and permissions for the SQL Server
service. It needs to be a domain account with the
appropriate access. Sounds like you could be running the
service under LocalSystem which does not have access to
network resources.
-Sue
On Tue, 6 Apr 2004 12:23:32 -0700, "Eric"
<anonymous@.discussions.microsoft.com> wrote:

>I cannot bulk insert a file from a network drive. Getting
>an error that access is denied. However, if I run the
>file name from the start menu it will open the file just
>fine or if I run the bulk insert from the local drive of
>the server it runs fine.
>The directory on the network is everyone full control.
>Any idea's?|||Hi,
The Service startup account for MSSQL server service should have privilage
to access the file in the destination machine.
To do this
1. Start MSSQL server service using a Domain OS User
2. That user should have access to the destination machine share as well as
the file to load.
3. Incase if you change the Startup service account you need to restart the
service to make the changes come into effect.
4. After this try login to Query Analyzer and execute the Bulk insert again
by providing the UNC path.
Thanks
Hari
MCDBA
"Eric" <anonymous@.discussions.microsoft.com> wrote in message
news:1644601c41c0c$a60d20c0$a601280a@.phx
.gbl...
> I cannot bulk insert a file from a network drive. Getting
> an error that access is denied. However, if I run the
> file name from the start menu it will open the file just
> fine or if I run the bulk insert from the local drive of
> the server it runs fine.
> The directory on the network is everyone full control.
> Any idea's?