<jbzcooper@gmail.com> wrote in message
news:1138315588.689076.326990@g14g2000cwa.googlegroups.com...
> Ok, perhaps I'm a moron.. believe me, I'd be glad to admit it if I
> could just get this fixed.
>
> We're trying to merge replicate data via https, we have installed the
> CA certificate and can connect to the replisapi.dll through IE. I used
> the following script to generate the subscription:
>
> DECLARE @publication AS sysname;
> DECLARE @publisher AS sysname;
> DECLARE @publicationDB AS sysname;
> DECLARE @websyncurl AS sysname;
> DECLARE @login AS sysname;
> DECLARE @password AS nvarchar(512);
>
> SET @publication = N'tables';
> SET @publisher = N'server';
> SET @publicationDB = N'database';
> SET @websyncurl = 'https://webserver/WebSync';
> SET @login = N'websql\user';
> Set @password = N'pass';
>
> USE [LocalDB]
> EXEC sp_addmergepullsubscription
> @publisher = @publisher,
> @publication = @publication,
> @publisher_db = @publicationDB,
> @subscriber_type = N'anonymous';
>
> EXEC sp_addmergepullsubscription_agent
> @publisher = @publisher,
> @publisher_db = @publicationDB,
> @publication = @publication,
> @distributor = @publisher,
> @job_login = @login,
> @job_password = @password,
> @use_web_sync = 1,
> @internet_url = @websyncurl,
> @internet_login = @login,
> @internet_password = @password,
> @enabled_for_syncmgr = 'true';
> GO
>
> This creates the subscription locally but gives me the error
> "websql\user not a valid Windows account". I tried changing the
> job_login & job_password to a local account and the subscription was
> added without errors. When I go to start the syncronization I get the
> error: "The system cannot find the file specified." The underlying
> error here is with the proxy. For some reason when it tries to connect
> it isn't passing the proper credentials or something.
>
> Anyway, any I'd appreciate any help or direction. If I find out what's
> wrong I'll go ahead and post it.
> JC
>