Hi Ramesh

Thanks a lot for your fast answer.

I will try to do this today.

Regards

Reto

Hi Joe and Ramesh

if I use a SQL server account with the needed privileges it works fine!

So there is a problem using Windows Accounts.

Ramesh, could you please explain how to...

Hi John

having exact the same problem...

Have you found a solution with the security problem for bulk load?

As it seems to be a bug in SQL Server 2005 (SP2) there is...

Hi Rajan Varghese

thanks for the answer.

It does not help, our mssqlserver 2005 service account uses a Windows domain account with admin privileges. For test, I have setup this account...

Hi Vidhya Sagar

thanks for your replay.

The SQL Server service account is a Windows Domain Administrator account and has all the needed privileges.

If I'm logged in on the sql server...

Hi John

I'm having the same problem here with Windows Authentication for bulk insert:

Cannot bulk load because the file "\\WXPPRO-xxx98\C_Drive\SPAImport.txt" could not be opened. Operating system error code 5(Access is denied.).

If...