sql server replication: Hi all,

I have configured a snapshot replication. The distributor is a different
machine than the publisher. Both of then connect each other by using sa
password. Now I changed the sa password at the publisher server and (of
course) the distributor can't connect to de publisher to generate the
snapshot. Then I updated the new password of the publisher, in the
Enterprise Manager Distributor/Security/Linked Servers/publisher server
name. But it looks like it is not enought. The snapshot agent continues to
fail. Where else should I update the password?

Thanks in advance
fdina

Can you enter the password for the publisher on the snapshot agent to the
new sa password?

For example, drill down on the distributor, replication monitor, agents, and
right click on the snapshot agent, select agent properties, and select steps
and then double click on run agent. In the commands box locate the
distributorsecrity mode. If it is 1 make it 0 and add -distributorPassword
(enter you password) and -distributoraccount (enter your account) so it
looks like this:

-Publisher [MyPublisher] -PublisherDB [MyPublicationDatabase] -Distributor
[MyDistributor] -Publication [MyPublication] -DistributorSecurityMode
0 -DistributorPassword [MyPublisherPassword] -DistributorAccount
[MyPublisherPassword]

Click Appy, OK, Apply, OK and restart your agent.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]