August 25, 2008 at 3:35 am
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
which is the error message?
August 25, 2008 at 4:00 am
cannot access the subscriber database.
..>>..
MobashA
August 25, 2008 at 5:07 am
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
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy