Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mmcdonald2khome
Starting Member
1 Post |
 Posted - 2011-05-08 : 01:37:39
|
| I am having some issues on SQL Server 2005 Express on Windows Vista. I installed SQL Server using SQL Authentication. I'm logged in as the sa account via a c# program. I attempt to run a BULK INSERT using a file that I have generated via code in the user's temp folder. When it attempts to run I receive the following error code: SQLException: Cannot bulk load because the file ... could not be opened. Operating system error code 5(Access is denied). I run the exact same code on SQL Server 2008 installed with Windows Authentication and it runs just fine. Is there something special I need to do to "map" the sa SQL account to use the current user's temp folder for BULK INSERT? Sorry if this is a silly question. I've been searching the net for hours to find a solution. Yet I have not found anything up to this point. Thanks,Michael McDonald |
|
|
|
|
|
SQL Server 2005 Express - BULK INSERT Error Code 5