sql server replication: WSM only supports "storing" of windows authentication credentials since SP
1, I believe. The storing of SQL authentication credentials was considered a
security risk and disabled.


--
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

[quoted text, click to view]

Hello everyone.

We have a bit of a problem with Windows Synchronisation Manager.

Basically, we have two domain servers (not the same domain) that have a db
on a SQL 2000 SP3a server. Those servers have a merge replication and
everything works as it should until we set the Syncronisation Manager to
syncrosnise the database on a schedule.

Basically, the problem is that we cannot make the mobsync remember the
password for the sql account we created for the replication. Every single
time it pops with the question to enter the password.

As you can appreciate that is a huge problem as the replication should
happen during off-hours and without any personel present.

Any help in resolving this problem appreciated.

For all those that helped us creating inter-domain replication between DomA
and DomB huge thanks. We just re-installed the DomB and everything runs like
clockworks.

BR,

GAZ

Or a bit more basic.

Is there a way (or some piece of software) that would do the following on a
Win 2000 SP4 / SQL 2000 SP3a server:

1. Initiate a dial-up connection on schedule
2. Start a replication process with a SQL account and its password
3. Disconnect the dial-up connection

Thank you all,

GAZ