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 |
|
pug2694328
Posting Yak Master
166 Posts |
 Posted - 2007-09-21 : 12:14:18
|
| I'm setting up a new 2005 server and bulk insert is failing with:Msg 4861, Level 16, State 1, Line 1Cannot bulk load because the file "\\FILESERVERNAME\sharedfolder\filename.txt" could not be opened. Operating system error code 5(Access is denied.).Here's my BULK INSERT statement (though I'm pretty sure there's nothing wrong with it): BULK INSERT #FIRSTROW FROM '\\FILESERVERNAME\sharedfolder\filename.txt' WITH ( DATAFILETYPE = 'char', ROWTERMINATOR = '\n', LASTROW = 1 )If I run the same transact SQL when remote desktopped into the new server (under the same login as my remote computer), it imports the file without errors.My old SQL 2000 server lets me bulk insert the file without errors even from my client desktop.I have no problems bulk inserting using the same TSQL from a client computer on the old server.Any thoughts on what could be causing this?Do I need to set some kind of proxy?My windows networking skills are mediocre, please give detailed instructions if there's something I need to configure.Thanks! |
|
|
sbalaji
Starting Member
48 Posts |
Posted - 2007-09-21 : 14:05:11
|
| If u r in Windows 2003 server,then there is some domain level security setting,u r network admin could help u. |
 |
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2007-09-21 : 23:09:05
|
| And, you might have better luck with your SQL Server 2005 question if you posted it in the SQL Server 2005 forum...--Jeff Moden |
|
|
|
pug2694328
Posting Yak Master
166 Posts |
Posted - 2007-09-24 : 12:10:30
|
| Unfortunately, we're a little shop and don't have an experienced admin. So I'm it : ). Jeff M, thanks for the advice... is there a way to roll this convo to the 2005 forums?This morning I've been following the advice found here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=928173&SiteID=1It looks promising, but I'm still unable to bulk insert from a client despite having setup delegation and restarting the server service. |
|
|
|
pug2694328
Posting Yak Master
166 Posts |
Posted - 2007-09-24 : 14:56:52
|
| Something else that might be helpful.If i logon to the server from a client machine, using the sa account, I can run the bulk insert without errors. |
|
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2007-09-24 : 18:32:41
|
| If you check Books Online, you'll see that need to be logged in as something the either has "SA" privs or is a member of the BULK INSERT ADMIN role.--Jeff Moden |
|
|
|
|
|
|
|
|
remote bulk insert fails