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 |
|
lauramayer
Posting Yak Master
152 Posts |
 Posted - 2004-04-07 : 11:01:17
|
| Good morning,I am trying to run this statement:BULK INSERT dbo.[test] FROM 'T:\yardcheck\data\Upload.txt' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )I have had the DBA give me BulkAdmin permissions but it doesn't seem to be enough. When I run it I get this message:Server: Msg 4861, Level 16, State 1, Line 1Could not bulk insert because file 'T:\yardcheck\data\Upload.txt' could not be opened. Operating system error code 1317(The specified user does not exist.)Anyone know how I can fix this? I am a member of the domain by the way.ThanksLaura |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-04-07 : 11:04:04
|
| Are you using windows authentication or a SQL Login? If it's a SQL login you probably won't have permissions on that file.Raymond |
 |
|
|
lauramayer
Posting Yak Master
152 Posts |
Posted - 2004-04-07 : 12:38:11
|
| Windows authentication. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-07 : 12:41:09
|
| So does this file exist on the database server:T:\yardcheck\data\Upload.txt?BULK INSERT requires the path to be valid from the database server's perspective and not from the client' perspective unless the client is the database server.Tara |
|
|
|
lauramayer
Posting Yak Master
152 Posts |
Posted - 2004-04-07 : 14:12:50
|
| Tara,Yes, its there. I uploaded it first.Laura |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-07 : 14:17:59
|
| Here is what I would suggest:Log into the database server using the Windows account that is getting the error. Go to Start, then Run, type in T:\yardcheck\data\Upload.txt and hit OK. If the file comes up, then it should work in Query Analyzer. If it doesn't, then you need to resolve whatever error is displayed.Tara |
|
|
|
lauramayer
Posting Yak Master
152 Posts |
Posted - 2004-04-08 : 06:13:44
|
| Tara,Thanks so much. We're working in a Citrix environment over novell and windows active directory, so it was having problems figuring out how to resolve it, your tip worked.Thanks againLaura |
|
|
|
|
|
|
|
|
Permissions problem?