Groups | Blog | Home
all groups > sql server replication > may 2006 >

sql server replication : Replication Manager Password doesn't persist


Paul Ibison
5/5/2006 12:00:00 AM
Jack,
replication manager is used for Access replication - are you sure this is
what you're using?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Jack T.
5/5/2006 1:22:15 AM
I set you merge replication and it is working fine. The only thng that
drives me nuts is that when I set up the passwords inside Windows
Replication Manger in XP on a subcriber, it doesn't remember the passwords
for the subscriber, publisher, or distributor from one session to the next.
I don't know if it is supposed to work that way or not, but I would like a
way around that.

Thanks!

Hilary Cotter
5/5/2006 5:56:19 AM
If you are using SQL authentication the passwords are not stored, and you
will be prompted to enter them each time. This is due to a security risk
with storing sql passwords.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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]

Jack T.
5/5/2006 10:50:12 PM
[quoted text, click to view]

OK, that's what I need to know

Thanks,
Jack T.

[quoted text, click to view]

AddThis Social Bookmark Button