Showing posts with label sqlmergeclass. Show all posts
Showing posts with label sqlmergeclass. Show all posts

Monday, March 19, 2012

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