[DB - BULK INSERT for mass insertion ] authorization needed

[teo]

Hallo,

I'm performing a mass insertion
from a text file to a db table
with AdoNet commands, like this:

myCommand.Comma ndText = "BULK INSERT ..."

from a Win form
no problem

but

from a Web form
(the same command, on the same db, on my pc)
I receive a message about a needed authorization

The message (Italian language):
"L'utente non è autorizzato a utilizzare
l'istruzione per il caricamento di massa."

(It tells I have non authorization
to perform the mass insertion)
What I need
and
where have I to set it?

[Rad [Visual C# MVP]]

Hello Teo,

What account does you asp.net application use to connect to the
database? Are you using sql authentication or windows authentication?

If you are using windows authentication, I suspect the problem might
be due to the fact that the account that asp.net runs under, ASPNET
does not have the rights to bulk insert into the database.

You can quickly correct this in Enterprise Manager/ Management studio
by assigning the user the Bulk Insert Administrators role

On Fri, 17 Nov 2006 19:18:52 +0100, teo <te*@inwind.itw rote:

>Hallo,

I'm performing a mass insertion
from a text file to a db table
with AdoNet commands, like this:

myCommand.Comm andText = "BULK INSERT ..."

from a Win form
no problem

but

from a Web form
(the same command, on the same db, on my pc)
I receive a message about a needed authorization

The message (Italian language):
"L'utente non è autorizzato a utilizzare
l'istruzione per il caricamento di massa."

(It tells I have non authorization
to perform the mass insertion)
What I need
and
where have I to set it?

--

Bits.Bytes.
http://bytes.thinkersroom.com