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
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 "asd" wrote in message news:%23QKz62PJGHA.3492@TK2MSFTNGP09.phx.gbl... > 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 >
Figured as much. Thanks for the answer. We finally decided that it is not worth the trouble and decided to let the client synchronise the server whenever they want to (it actually works better for the client as they can update whenever they feel like it). Thanks once again. BR, GAZ "Hilary Cotter" wrote in message news:unk0bMSJGHA.1728@TK2MSFTNGP09.phx.gbl... > 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 > > "asd" wrote in message > news:%23QKz62PJGHA.3492@TK2MSFTNGP09.phx.gbl... >> 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 >> > >
