Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102

    Unanswered: Snapshot Delivery Problem

    Hi
    I am tring to apply snapshot for transactional publication - snapshot is created and when distribution agent delivers, it succeeds till it reaches the bulk insert for our one table 'xxx' - when it reaches this stage the error is:
    Could not bulk insert because file '\\ccc\d$\Data\MSSQL\ReplData\unc\CAIN_BingoCafe_T P_TRANS_BingoCafe_TP\20031119040134\casa_creditcar d_trfff47d64_135.bcp' could not be opened. Operating system error code 1326(Logon failure: unknown user name or bad pa
    (Source: EVE (Data source); Error number: 4861)

    Why would it need different security options for one file out of the whole snapshot?
    If anyone can help, it would be greatly appreciated...
    Des

  2. #2
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Re: Snapshot Delivery Problem

    maybe it's the first file generated
    supposing that the others bulks did not generate files because no data had to be exported.

  3. #3
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    no, when viewing session details at least 15 other tables had successfully bulk copied their data, then always fails on that one - though I think it may be the last one and it is actually failing to wrap up the entire task (perhaps with xp_cmdexec), not just bcp that file...
    have made some adjustments, and am waiting for snapshot to generate again...
    thx
    des

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •