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 |
|
jet
Starting Member
2 Posts |
 Posted - 2002-04-01 : 19:37:34
|
| hi people! i can't perform bulk insert on a text file located in a remote pc(rmgo_01_nvl). sql server 7 returns the error- "Server: Msg 4861, Level 16, State 1, Line 1Could not bulk insert because file '\\rmgo_01_nvl\user1\share\isda\march\switch_dump\ewsd\davao_metro.txt' could not be opened. Operating system error code 1326(Logon failure: unknown user name or bad password.)." the remote pc(rmgo_01_nvl), which runs on NT Server 4.0, can be accessed by everyone here in our group without providing a logon password!thanks very much. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-01 : 19:44:53
|
| HiYou would need to allow access to the account that SQL Server is running under.Damian |
 |
|
|
|
|
|
BULK INSERT THROUGH NETWORK