How to use PublisherEncryptedPassword?

I'm doing merge replication over the net using the ActiveX replication
library.
The SQLMergeClass has a property called PublisherEncryptedPassword
(string). There is absolutely no documentation for this anywhere on the
web (that I can find, anyhow).
How do I use this? Do I have to provide an encrypted password? If so,
what type of encryption do I use?
I'm assuming that this exists to enable me to send an encrypted
password instead of plain text.
Thanks for any info -
JJ
have you tried
declare @.retcode int
declare @.distributor_enc_password nvarchar(524)
set @.distributor_enc_password='stuff'
EXEC @.retcode = master.dbo.xp_repl_encrypt @.distributor_enc_password OUTPUT
print @.distributor_enc_password
print @.retcode
This property is hidden and undocumented. It could be used in WSM.
Hilary Cotter
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
"JJ" <joe.jabour@.gmail.com> wrote in message
news:1123031272.303748.285010@.g44g2000cwa.googlegr oups.com...
> I'm doing merge replication over the net using the ActiveX replication
> library.
> The SQLMergeClass has a property called PublisherEncryptedPassword
> (string). There is absolutely no documentation for this anywhere on the
> web (that I can find, anyhow).
> How do I use this? Do I have to provide an encrypted password? If so,
> what type of encryption do I use?
> I'm assuming that this exists to enable me to send an encrypted
> password instead of plain text.
> Thanks for any info -
> JJ
>
|||Thanks - that shows me how to encrypt my password, but I am not able to
authenticate with it for some reason.
Does PublisherEncryptedPassword replace PublisherPassword?
I am not using WSM.
JJ