SQL replication problem

[Sandy Lee]

Hi,

I tried to reestablish a broken SQL replication problem, but the Pull Subscription from the Subscriber failed.

I get : The process could not connect to the Distributor "Publisher". I'm running CCM 4.1(3) and I think this has something to do with the SQL authentication beeing in mixed mode.

My question is : For the pull subscription, do I use 'Impersonate the SQL Server Agent' ? Is that equivalent to 'Use Windows authentication' from the SQL server registration ?

Thanks.

[gpulos]

are you manually creating the subscription or using DBHelper?

to reEstablish a broken sql subscription, there are two methods..

1) use DBHelper - see this link for more info:

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801e7ddf.shtml

2) manually create SQL subscription - see this link for more info:

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801d11a6.shtml

[Sandy Lee]

Hi,

I was doing it manually. I ran DBHelper and it solved it. I checked for the parameter and it effectively configured with , this was what I was looking for.

Thank you.