April 2, 2009 at 1:50 am
I have Windows Server 2003 Enterprise OS, SQL 2005 Developer installled, And I am getting error with Web Synchronization with merge replication, I am stating here what i have done so till this time
- Configure a Publication with merge replication and pull subscription , Distributor & Publisher are on same machine, after Create a user Under Sysadmin Role, Create user for Publishing Database with db_owner schema, assign all permission to it,Running snapshot agent under SQL SERVER agent account, And for Web Synchronization I create account with DYNDNS.com and Create MyServer.dyndns.biz hostname with my static IP, And At publisher I assign address MyServer MyServer.dyndns.biz, configure web Synchronization at publisher as per Microsoft Site.
- At IIS I create a virtual directory under Default Web Site,named TestPublication,Create new user,IIS_user for IIS_WPG Group, Create new Application pool and Configure its identity with New Creted IIs_user,and set new application pool at my virtual directory application pool setting.At Default web site properties, I assign my static IP at WebSite Identification, At directory security tab,I enable anonymous access with "PINAAK-3\IUSR_PINAAK-3", select Basic authantication, Dafult domain as dyndns.biz, realm as MyServer.dyndns.biz, I create SSL trial with Thawte,but my IIS detected that there is not sufficient information available, and if i use self assigned cerificate with selfssl, At subcriber my IP cant be resolved,
- I create subcriber with pull subcription,give https://MyServer.dyndns.biz/TestPublication/replisapi.dll address,
running its agent under SQL server agent account.
I try web synchronization two times, first with https://***.**.**.***(My static IP)/TestPublication/replisapi.dll address, and configure all its related items as this address, create self ssl for that with static IP as its common name, At subcriber i get diagnosis window successful, and at authantication I gave MyServername\Administrator. But at second time login it ask again my UserName, Password.Here the problem is, at subcriber when i click View Subscrption status,"Specified File not found",error occured.
At second time I try with address https://MyServer.dyndns.biz/TestPublication/replisapi.dll, and this time also dignosis window is successful, but it ask me UserName, Password if i enter dignosis mode again. Here the problem is error "The Proxy Auto-configuration URL was not found.", comes.
*******************************************
April 2, 2009 at 1:52 am
Here is the error log
*******************************************
This log comes to Subcriber job history, when address is
https://MyServer.dyndns.biz/TestPublication/replisapi.dll
-----------------------------------------------------------------------------------------------------------
a> Date4/1/2009 8:29:27 PM
LogJob History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID1
ServerPINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step NameRun agent.
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
The replication agent has been successfully started. See the Replication Monitor
for more information.
b> Date4/1/2009 8:29:27 PM
LogJob History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID1
ServerPINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step NameRun agent.
Duration00:00:03
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
-XCancelEventHandle 00000414
2009-04-01 14:59:27.671 Connecting to Subscriber 'PINAAK-1\PINAAK1'
2009-04-01 14:59:27.812 Connecting to Subscriber 'PINAAK-1\PINAAK1'
2009-04-01 14:59:27.843 The upload message to be sent to Publisher
'PINAAK-3\PINAAK3' is being generated
2009-04-01 14:59:27.843 The merge process is using Exchange ID
'3148BDDD-384E-4F63-9EC6-A596612FDCE5' for this web synchronization
session.
2009-04-01 14:59:30.421 The Proxy Auto-configuration URL was not found.
2009-04-01 14:59:30.421 Category:NULL
Source: Merge Process
Number: -2147209324
Message: The Proxy Auto-configuration URL was not found.
2009-04-01 14:59:30.421 Category:NULL
Source: Merge Process(Web Sync Client)
Number: -2147023888
Message: The Merge Agent could not connect to the URL
'https://pinaak3.dyndns.biz/TestPublication/replisapi.dll' during Web
synchronization. Please verify that the URL, Internet login credentials and proxy
server settings are correct and that the Web server is reachable.
c> Date4/1/2009 8:29:27 PM
LogJob History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID1
ServerPINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step NameRun agent.
Duration00:00:03
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: Pinaak-1\Administrator. The replication agent encountered a
failure. See the previous job step history message or Replication Monitor for more
information. The step failed.
d >
Date4/1/2009 8:29:27 PM
LogJob History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID0
ServerPINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step Name(Job outcome)
Duration00:00:03
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
The job failed. The Job was invoked by User sa. The last step to run was step 1
(Run agent.).
-------------------------------------------------------------------------------------------------------------
This log comes to Subcriber job history, when address is
https://MyServer.dyndns.biz/TestPublication/replisapi.dll
-------------------------------------------------------------------------------------------------------------
a>Date4/1/2009 8:46:49 PM
LogJob History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID1
ServerPINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step NameRun agent.
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
The replication agent has been successfully started. See the Replication Monitor
for more information.
b> Date4/1/2009 8:46:49 PM
LogJob History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID1
ServerPINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step NameRun agent.
Duration00:00:03
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
-XCancelEventHandle 00000440
2009-04-01 15:16:49.562 Connecting to Subscriber 'PINAAK-1\PINAAK1'
2009-04-01 15:16:49.687 Connecting to Subscriber 'PINAAK-1\PINAAK1'
2009-04-01 15:16:49.734 The upload message to be sent to Publisher
'PINAAK-3\PINAAK3' is being generated
2009-04-01 15:16:49.765 The merge process is using Exchange ID
'525DD6A9-1A59-4D2B-9DD4-4DE48BA5FDBC' for this web synchronization
session.
2009-04-01 15:16:52.125 The Proxy Auto-configuration URL was not found.
2009-04-01 15:16:52.125 Category:NULL
Source: Merge Process
Number: -2147209324
Message: The Proxy Auto-configuration URL was not found.
2009-04-01 15:16:52.125 Category:NULL
Source: Merge Process(Web Sync Client)
Number: -2147023888
Message: The Merge Agent could not connect to the URL
'https://219.64.82.212/TestPublication/replisapi.dll' during Web synchronization.
Please verify that the URL, Internet login credentials and proxy server settings are
correct and that the Web server is reachable.
c > Date4/1/2009 8:46:49 PM
LogJob History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID1
ServerPINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step NameRun agent.
Duration00:00:03
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: Pinaak-1\Administrator. The replication agent encountered a
failure. See the previous job step history message or Replication Monitor for more
information. The step failed.
d>
Date4/1/2009 8:46:49 PM
LogJob History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID0
ServerPINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step Name(Job outcome)
Duration00:00:03
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
The job failed. The Job was invoked by User sa. The last step to run was step 1
(Run agent.).
+++++++++++++++++++++++++++++++++++++++++
Here is th log at System Event Log
--------------------------------------------------------------------------------------------------------------
Event log:
SQL Server Scheduled Job
'PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0'
(0x3710058FCC349B479E94B09297DF0AF4) - Status: Failed - Invoked on:
2009-04-01 20:35:30 - Message: The job failed. The Job was invoked by User
sa. The last step to run was step 1 (Run agent.).
22>>
DCOM was unable to communicate with the computer PINAAK-3 using any of the
configured protocols.
The certificate received from the remote server was issued by an untrusted
certificate authority. Because of this, none of the data contained in the certificate
can be validated. The SSL connection request has failed. The attached data
contains the server certificate.
+++++++++++++++++++++++++++++++++++++++
SQL Server Scheduled Job
'PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0'
(0x3710058FCC349B479E94B09297DF0AF4) - Status: Failed - Invoked on:
2009-04-01 20:31:40 - Message: The job failed. The Job was invoked by User
sa. The last step to run was step 1 (Run agent.).
Here Pinaak-3 is Publisher server, Pinaak-1 is subcriber server.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply