|
Subject:
|
Using Bulk Insert with SQL Server 2005
|
|
Posted By:
|
ninel
|
Post Date:
|
8/29/2006 11:07:12 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:
<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
|
|
Reply By:
|
SQLScott
|
Reply Date:
|
8/29/2006 3:48:43 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...
|
|
Reply By:
|
ninel
|
Reply Date:
|
8/29/2006 3:52:05 PM
|
Turns out that I need to give the bulkAdmin role to the Network Service user not the ASPNET user.
|
