I did not have such issue when I used the integrated connection string (Integrated Security=true) to the remote server. However, I encountered an
issue when I included the user Id and password in the connection string.
There are two methods in the class “SqlWebSyncService.cs”
public DbSyncScopeDescription GetScopeDescription()
{
Log("GetSchema: {0}",
this.peerProvider.Connection.ConnectionString);
DbSyncScopeDescription scopeDesc =
SqlSyncDescriptionBuilder.GetDescriptionForScope(SyncUtils.ScopeName, (SqlConnection)this.dbProvider.Connection);
return scopeDesc;
}
public bool NeedsScope()
{
Log("NeedsSchema: {0}",
this.peerProvider.Connection.ConnectionString);
SqlSyncScopeProvisioning prov =
new SqlSyncScopeProvisioning((SqlConnection)this.peerProvider.Connection);
return !prov.ScopeExists(this.peerProvider.ScopeName);
}
The first method worked correctly, but the second cut the password off, thus the user Id cannot log in to the database. It worked fine when I hardcoded
a valid connection string here.
If you have any experience with this, could you please give me some advice?
Thanks!
