Post reply

Replication problem

  • August 25, 2008 at 3:35 am

    #130786

    hello.

    am trying to configure replecation between two servers one on my domain(default port, subscriber) and the other one (publisher) is on a sub domain(prot xxxx)

    , but am having a problem: the job which copy from the publisher to the subscriber wont run correctly.

    ..>>..

    MobashA

  • August 25, 2008 at 3:57 am

    #862437

    which is the error message?

  • August 25, 2008 at 4:00 am

    #862438

    cannot access the subscriber database.

    ..>>..

    MobashA

  • August 25, 2008 at 5:07 am

    #862457

    this is the error msg:

    2008-08-25 11:05:59.732 Agent message code 20084. The process could not connect to Subscriber 'SRV-04'.

    2008-08-25 11:05:59.810 Category:NULL

    Source: Microsoft SQL Native Client

    Number: 18456

    Message: Login failed for user 'sa'.

    ..>>..

    MobashA

  • August 25, 2008 at 5:18 am

    #862460

    there is a procedure sp_updatesubscriber which you could use to change the password for your distribution db to accomodate the new sa pwd.

  • August 25, 2008 at 8:22 am

    #862555

    When I used replication across domains, I created a Windows account on each server with the same name & same password.

  • August 25, 2008 at 8:42 am

    #862564

    i have created a domain account and add it to both sql servers, it worked finally.

    thanks

    ..>>..

    MobashA

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply