Using Bulk Insert with SQL Server 2005

ninel · August 29th, 2006, 11:07 AM

I have a web page that prompts a user to select a csv file. Using a Bulk Insert the data is loaded into a SQL Server 2005 table.

I have been using the Bulk Insert with SQL Server 200 with no problems, but with 2005 I am getting the error "You do not have permission to use the bulk load statement".

My web.config file has the following connection string:

Code:

<add key="connectionString" value="Server=(local);Database=BroadCastOne;trusted_connection=true" />

I've given bulkAdmin role to the ASPNET user. It's still not working. What am I doing wrong?

Any help is greatly appreciated,
Ninel

SQLScott · August 29th, 2006, 03:48 PM

Ninel, I will look into this a little bit more, but you might want to take a look BOL:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/18a64236-0285-46ea-8929-6ee9bcc020b9.htm

Especially the section for Security Considerations. I'll see what i can find...

ninel · August 29th, 2006, 03:52 PM

Turns out that I need to give the bulkAdmin role to the Network Service user not the ASPNET user.