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 |
|
pazzy11
Posting Yak Master
145 Posts |
 Posted - 2008-05-26 : 08:53:01
|
| Hi when i try and do a simple bulk insert i get this error.Operating system error code 1326(Logon failure: unknown user name or bad password.).yet i can access the file fine when i eneter the path into the run box on the same SQL server .. ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-26 : 08:54:28
|
It depends under which context the query is run.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
pazzy11
Posting Yak Master
145 Posts |
Posted - 2008-05-26 : 09:02:47
|
| Well its a simple [CODE]CREATE TABLE tmp_table (line varchar(8000))bulk INSERT tmp_table FROM '\\172.92.11.2\DOCM\f\y\e\4707908.txt'[/CODE]Could it be the user has not the proper permissions ? The roles the user has at the moment is public & db_owner ... should it have more like access_admin, data_writer .. etc .. ? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-26 : 09:09:31
|
The file and folder in the query need to know that the user running the query has access to the file and folder.So yes, it's security issue.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-26 : 20:55:52
|
| Does sql service startup account have permission to access that file? |
|
|
|
|
|
|
BULK INSERT