merge replication only need passwrd first time -- sql server replication

jensenove NO[at]SPAM netscape.net
4/6/2006 12:18:47 PM

Hello

I have an applicatiuon on a pda where i can synchronize the pda with
sql server 2000
When I start the application on open the synchronize window i have to
enter a user id and password.

repl.InternetLogin = userId
repl.InternetPassword = Password

I start the synchronization and it works.
The second time i synchronize it still works even with no password.
Why is that? I have to stop the application and start it again for it
to work.
If I enetr a wrong password when I synchronize the first time, I gett e
message saying: Authentication failed on the computer running IIS
I would like to get this message all the time when I synchronize with
an incorrect password.
What can I be doing wrong.

Hilary Cotter
4/6/2006 7:09:28 PM

What form of authentication are you using on your IIS Server. Is it possible
that you have a blank password for the account userID?

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

sql server replication : merge replication only need passwrd first time