none
בעית WEB SYNCRONIZATION RRS feed

  • שאלה

  • שלום רב

    אני מנסה להגדיר סינכרון דרך ה- WEB בין שני שרתי SQL 2005, אני עשיתי את כל ההגדרות לפי מה שמופיע בכתובת הזאת:

    http://technet.microsoft.com/en-us/library/ms151255(SQL.90).aspx

    אני עדיין לא מצליח להפעיל את ה- AGENT בצד ה- SUBSCRIBER, אני מקבל את ההודעה הבאה:

    The system cannot find the file specified.

    בקובץ ה- replmerg.log אני רואה רת הפרטים הבאים:

    CReconcilerTask               , 2011/04/30 15:27:27.578, 5736,   406,  S1, INFO: =============== STARTING OF MERGE ===============
    CReconcilerTask               , 2011/04/30 15:27:27.578, 5736,   485,  S2, INFO: CommandLine:  "C:\Program Files\Microsoft SQL Server\90\COM\replmerg.exe" -Publisher [NATEEVEXPRESS] -PublisherDB [TestNTours] -Publication [TestNToursRep] -Subscriber [DEV-SERVER\DEVSERVER2005] -SubscriberDB [TestNtours] -SubscriptionType 1 -SubscriberSecurityMode
    CReconcilerTask               , 2011/04/30 15:27:27.578, 5736,   485,  S2, INFO:   1 -Distributor [NATEEVEXPRESS] -XJOBID 0xA91E29790CB475498D4E12F626C747EA -XJOBNAME [NATEEVEXPRESS-TestNTours-TestNToursRep-DEV-SERVER\DEVSERVER200-TestNtours- 0] -XSTEPID 1 -XSUBSYSTEM Merge -XSERVER [DEV-SERVER\DEVSERVER2005] -XCMDLINE 0 -XCancelEventHandle
    CReconcilerTask               , 2011/04/30 15:27:27.578, 5736,   494,  S2, INFO:   00000708 -XParentProcessHandle 00000728
    Replprov.dll                  , 2011/04/30 15:27:27.703, 5736, 19858,  S2, INFO: Reading profile from Subscriber: ProfileName:
    WinHttpClient                 , 2011/04/30 15:27:27.734, 5736,  2564,  S1, ERROR: CWinHttpClient: The system cannot find the file specified.
    , 2
    WinHttpClient                 , 2011/04/30 15:27:27.734, 5736,  2501,  S1, ERROR: ErrNo = 0x80040002, ErrSrc = <null>, ErrType = 10, ErrStr = The system cannot find the file specified.

    WinHttpClient                 , 2011/04/30 15:27:27.734, 5736,   738,  S1, ERROR: CWinHttpClient::RetrieveProxySettingsAndApplyToSession: WinHttpGetIEProxyConfigForCurrentUser failed for user SQLReplication, got error 2.
    WinHttpClient                 , 2011/04/30 15:27:27.734, 5736,  2501,  S1, ERROR: ErrNo = 0x80045673, ErrSrc = <null>, ErrType = 10, ErrStr = The Merge Agent failed to connect to the Internet proxy server for user 'SQLReplication' during Web synchronization. Ensure that the proxy server settings are correctly configured in Internet Explorer, or specify the -InternetProxyServer parameter when starting the Merge Agent.
    WinHttpClient                 , 2011/04/30 15:27:27.734, 5736,   479,  S1, ERROR: CWinHttpClient::InitializeInternet: Failed.
    replrec!FillErrorInfo         , 2011/04/30 15:27:27.734, 5736, 19955,  S1, ERROR: ErrNo = 0x800736b7, ErrSrc = <null>, ErrType = 9, ErrStr = The Merge Agent could not connect to the URL 'https://213.8.25.146/SQLReplication/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.
    DatabaseReconciler            , 2011/04/30 15:27:27.734, 5736, 20067,  S2, :T:,110,0,6,,,,,,,
    DatabaseReconciler            , 2011/04/30 15:27:27.734, 5736, 20074,  S2, INFO: Session Highlights: FAIL, WEBSYNC_CLIENT,
    CReconcilerTask               , 2011/04/30 15:27:27.734, 5736,   641,  S1, INFO: =============== ENDING OF MERGE =================

    ניסיתי את כל הדרכים להתקדם וזה לא עזר.

    בברכה

    יזיד

     

    שבת 30 אפריל 2011 15:29