Re: using Integrated Security for bulk insert

Take a look into the below URL:-

http://support.microsoft.com/default.aspx?scid=kb;en-us;302621

Thanks
Hari

"royHe" <royHe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E6591B96-DAA6-497E-A717-CD934D776544@xxxxxxxxxxxxxxxx
I have a web service using using Integrated Security to access to the
database and make bulk insert.

I got the following error:

System.Web.Services.Protocols.SoapException: Server was unable to process
request. --->


System.Data.SqlClient.SqlException:


The current user is not the database or object owner of table
'OM_CRTransReport'. Cannot perform SET operation.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VehicleRentalSystem.DataAccess




.OM_CRTransLog.ImportCRTransactionLog(String pStrFilePath)
at
VehicleRentalSystem.BusinessFacade.CreditCardTransactionLog.ImportCRTransactionLog(String
pStrFilePath)
at
VehicleRentalSystem.Web.Service.CreditCardTransLogService.ImportCRTransactionLog(String
pStrFilePath)
--- End of inner exception stack trace ---

I assign the identity for the matching(ServerName$) with bulk insert
admin,
or even system admin, I still got the following error:

System.Web.Services.Protocols.SoapException: Server was unable to process
request. --->
System.Data.SqlClient.SqlException:
You do not have permission to use the BULK INSERT statement.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
VehicleRentalSystem.DataAccess.OM_CRTransLog.ImportCRTransactionLog(String
pStrFilePath)
at
VehicleRentalSystem.BusinessFacade.CreditCardTransactionLog.ImportCRTransactionLog(String
pStrFilePath)
at
VehicleRentalSystem.Web.Service.CreditCardTransLogService.ImportCRTransactionLog(String
pStrFilePath)

Thank you in advance for your help.



.