Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    101

    Unanswered: Replication help!!

    Hi,
    I'm trying to set up Transactional replication!
    If anyone has any info or help in monitoring and troubleshooting Transactional replication, please provide me.
    I really appreciate your help.
    Thanks

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Have you already tried to set it up, or you're asking how to? Without a specific question, not open-ended like the one you posted, your question will continue showing 0 in the number of answers...ooops, you already got 1 here...
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Apr 2004
    Posts
    101
    Hi,
    I set up Transactional replication with immediate update subscription option. I'm able to make changes on publisher successfully. But, when i try to change one value on table column it is erroring out with the following message!!
    Login Failed for User sa. Reason : not associated with SQL Trusted connection.
    What could be the reason.
    Any help is greatly appreciated.
    Thanks

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Make sure the publisher accepts standard SQL authentication...and of course, check spelling on sa password. Try to use Windows authentication instead, standard is not recommended.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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