Listing 1: The new and improved connection string

Dim remoteConnString As String = "Provider=sqloledb;
Data Source=MyServerName;
Database=SSCEExample;
Integrated Security=SSPI;
Persist Security Info=False"
'Dim remoteConnString As String = "Provider=sqloledb;
Data Source= MyServerName;
Database=SSCEExample;
User Id=sa;
Password = 2ReplMe!Baby"



Listing 2: Pointing RDA to the SSL connection and providing account information

'///RDA
'///Where to find the server agent via HTTP
'///requests.
Rda.InternetUrl =
"https://<MyMachineName>/SSCEExampleSynch/sscesa20.dll"
Rda.InternetLogin = txtName.Text
Rda.InternetPassword = txtPassword.Text






Listing 3: Replication code changes

'///Replication
'///Set Internet properties for
'///authentication/authorization with IIS/SQL
repl.InternetUrl =
"https://<MyMachineName>/SSCEExampleSynch/sscesa20.dll"
repl.InternetLogin = txtName.Text
repl.InternetPassword = txtPassword.Text

'///Set Publisher security properties.
repl.PublisherSecurityMode =
SecurityType.NTAuthentication
'repl.PublisherLogin = "sa"
'repl.PublisherPassword = "password"