471,571 Members | 984 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,571 software developers and data experts.

[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.CommandText = "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?
Nov 17 '06 #1
1 1883
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.itwrote:
>Hallo,

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

myCommand.CommandText = "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
Nov 17 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Jim Geissman | last post: by
5 posts views Thread by me | last post: by
20 posts views Thread by akej via SQLMonster.com | last post: by
6 posts views Thread by pk | last post: by
2 posts views Thread by Zarrin | last post: by
19 posts views Thread by Khafancoder | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.