what happens if you do the following from the subscriber?

https://Raff.domain.com/caroltesting/replisapi.dll"

and

https://Raff.domain.com/caroltesting/replisapi.dll?diag

Note that your url must be crafted to match the certificate.



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

I am trying to deploy web synchronisation between server and client. Some
basic setting up are as following:
1. Server -- SQL 2005 Standard Edition
2. Client -- SQL 2005 Express Edition
3. Sync Type -- Merge Sync
4. Subscription Type -- Pull Subscription
5. A publication (called CarolPub) is created at the server and a
subscription is created at subscriber
6. The SSL certificate is installed and IIS, Publication are both configured
for web sync and the web sync address is:
http://Raff/caroltesting/replisapi.dll

Now, I am writing the VB.net windows application to perform the web sync.
The VB code are:
' Create a connection to the Subscriber.
Dim conn As ServerConnection = New
ServerConnection("CAROL\SUBSCRIBER_CAROL")

Dim subscription As MergePullSubscription
Dim agent As MergeSynchronizationAgent

Try
' Connect to the Subscriber.
conn.Connect()

' Define the pull subscription.
subscription = New MergePullSubscription()
subscription.ConnectionContext = conn
subscription.DatabaseName = "AAL"
subscription.PublisherName = "RAFF"
subscription.PublicationDBName = "AAL"
subscription.PublicationName = "CarolPub"

' If the pull subscription exists, then start the synchronization.
If subscription.LoadProperties() Then

' Get the agent for the subscription.
agent = subscription.SynchronizationAgent

' Check that we have enough metadata to start the agent.
If agent.PublisherSecurityMode = Nothing Then

' Set the required properties that could not be returned
' from the MSsubscription_properties table.
agent.PublisherSecurityMode = SecurityMode.Standard
agent.PublisherLogin = "sa"
agent.PublisherPassword = "carol"

agent.Distributor = "RAFF"
agent.DistributorSecurityMode = SecurityMode.Standard
agent.DistributorLogin = "sa"
agent.DistributorPassword = "carol"

' Set optional Web synchronization properties.
agent.UseWebSynchronization = True
agent.InternetUrl = webSyncUrl
agent.InternetSecurityMode = SecurityMode.Integrated
agent.InternetLogin = "carol"
agent.InternetPassword = "carol"
End If

' Enable agent logging to the console.
agent.OutputVerboseLevel = 1
agent.Output = ""

' Synchronously start the Merge Agent for the subscription.
agent.Synchronize()

Else
' ' Do something here if the pull subscription does not
exist.

MessageBox.Show(String.Format( _
"A subscription to '{0}' does not exist on {1}", _
publicationName, subscriberName))
End If

Catch ex As Exception
' Implement appropriate error handling here.

MessageBox.Show(ex.StackTrace & ", " & ex.Message)
Finally
conn.Disconnect()
End Try

When I try to run the code, it thrown me a error "A security error occured".
but if manually test that https address in IE, it works. Does anyone know

The web sync URL I mentioned in the 1st post should be
"https://Raff/caroltesting/replisapi.dll"

The fowllowing links from subscriber thrown me the message of "Page cannot be
displayed". I used SelfSSL at the server for testing, but it did issed to
RAFF which is my server.

Thanks!

[quoted text, click to view]