July 12, 2005 at 6:32 am
Hi,
I am trying to bulkinsert from network system. Please find the test.txt file content given below.
As well the remaining bulk insert script also mentioned.
TEST.txt
-------------------------
Chris,Sully\n
Sian,Davies\n
Fiona,Phelp\n
Tania,Barra-Shaw\n
-------------------------
CREATE TABLE BulkInsertTest
(
Firstname varchar(20),
Surname varchar(20)
)
BULK INSERT Northwind.dbo.[BulkInsertTest]
FROM '\\STP3aw07\SampleFiles\test.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
As i m using Universal Naming Convention (UNC) for remote file sharing
but i am getting the given below error.
could not bulk insert because file '\\stp3aw07\Share\test.txt' could not be opened. Operating system error code 1326(Logon failure: unknown user name or bad password.).
Please help me
regarding permisons the user having all rights for bulkinsert permission
in the online books i found
Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.
as both of the conditions satisfy but still getting the same problems.
July 12, 2005 at 7:38 am
Does the account your SQL Server runs under have rights to access the share. Keep in mind it's not using your account, it's using the SQL Server service account. If it's set up to run under the local System account, then it most certainly does not have rights. If it's a domain user account, make sure that user account has rights to access the share.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply