Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gopaalakrishnan
Starting Member
1 Post |
 Posted - 2009-02-11 : 22:48:48
|
| Hi, I have two pc with windows xp o/s, both have installed sql server 2005 standard edition. I tried transactional replication in single computerwith pull and push subscription. Both are working well.I tried the same replication by making one pc as publisher and another one as subscriber using push subscription in publisher it is working.But when i tried pull subscription and see the synchronization status, it says could not connect to distributor. I chosen "Impersonating process account" for distributor on subscription process.Both computer not configured in a domain. Each have configured with it's machine account.Can any one help me?. The system architecture needed to do the pull subscription.Thanks,Gopal P. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-11 : 23:00:14
|
| I had this issue. Make sure the accounts the distibution agents run must have atleast db_owner permission in subscription database. |
 |
|
|
|
|
|
Problem on Pull Subscription