HiI'm currently setting up merge replication via scripts (as this will be used at various clients around the country). It's the first time I've done replication so have a few questions that BOL isn't too clear on.I began by setting it all up via Enterprise Manager and generating scripts for me to modify. My first concern was that sp_adddistributor was using a blank password (ie. for distributor_admin login) so I've changed this accordingly.However, I'm not sure where I need to set this password in the subsequent replication SPs. For example, sp_adddistpublisher has a @password parameter that BOL states is used by the replication agents to connect to the publisher. If I'm using @security_mode=1, so I need to set @password to the distributor_admin password, or do I just leave it blank?EXECUTE sp_adddistpublisher @publisher = 'MyServer', @distribution_db = 'MyDistDB', @security_mode = 1, @password = 'distributor_admin_password', -- DO I NEED THIS? @working_directory = 'MyWorkingDir', @trusted = 'false'
If not, do I need to use the @password in any of the other replication SPs? BOL doesn't seem to be clear where I need to specify any password I've set up for distributor_admin.Thanks for any helpPete
sp_adddistpublisher question
Posted - 2004-06-02 : 06:20:45