none
Merge Repl using SQL Compact 3.5 sp2 --> SQL 2012 is it possible?

    Question

  • Installed the latest server tools, (cumulative update 7)

    Mobile device (winmobile 6.1) syncs fine to sql server 2008 r2

    but not on 2012:

    2012/11/21 14:38:58 == SQLCESA Version ==> 3.5.8089.0
    2012/11/21 14:38:58 Thread=10D0 RSCB=1 Command=SYNC Hr=00000000 Failed to use 10.0 error components. Exiting... 0
    2012/11/21 14:50:48 Thread=10D0 RSCB=2 Command=SYNC Hr=00000000 Failed to use 10.0 error components. Exiting... 0

    this is a fresh sql 2012 install--

    Any ideas on fixing this?

    diag output:

    SQL Server Compact Server Agent Diagnostics

    2012/11/21 15:03:06

    General Information
    Item Value
    Server Name 98.1xx
    URL /ssce35/sqlcesa35.dll
    Authentication Type Anonymous
    Server Port 8888
    HTTPS off
    Server Software Microsoft-IIS/8.0
    Replication Allowed
    RDA Allowed
    Logging Level 1
    Impersonation and Access Tests
    Action Status ErrorCode
    Impersonate User SUCCESS 0x0
    ReadWriteDeleteMessageFile SUCCESS 0x0
    SQL Server Compact Modules Test
    Module Status ErrorCode Version
    sqlcerp35.dll SUCCESS 0x0 3.5.8089.0
    sqlcesa35.dll SUCCESS 0x0 3.5.8089.0
    Reconciler Test
    Reconciler Status ErrorCode
    11.0 Database Reconciler SUCCESS 0x0
    10.0 Database Reconciler FAILURE 0x80040154
    9.0 Database Reconciler FAILURE 0x80040154
    SQL Server Module Versions
    Module Version
    sqloledb.dll 6.2.9200.16384
    11.0 replrec.dll 2011.110.3000.0
    11.0 replprov.dll 2011.110.3000.0
    11.0 msgprox.dll 2011.110.3000.0

    Wednesday, November 21, 2012 8:03 PM

All replies

  • got farther:

    2012/11/21 17:50:28 == SQLCESA Version ==> 3.5.8089.0
    2012/11/21 17:50:28 Hr=00000000 SQLCE Server Agent Loaded - Version 3.5.8089.0
     0
    2012/11/21 17:50:28 Hr=80004005 ERR:Couldn't find existing RSCB 1

    --now it keeps crashing the iis app pool...

    Wednesday, November 21, 2012 10:59 PM
  • Very odd, we have already tried with success the CU 7 with SQL Server 2012 on Windows Server 2008 and Windows 8 Pro, with a .NET CF 3.5 application with SQL Server Compact 3.5SP2 running on Windows Mobile devices.

    Alberto Silva Microsoft MVP - Device Application Development - http://msmvps.com/AlbertoSilva moving2u - R&D Manager - http://www.moving2u.pt

    Wednesday, November 21, 2012 11:16 PM
  • hmmm, this is running on windows server 2012

    Wednesday, November 21, 2012 11:28 PM
  • Is your WM device using at least build 8088, otherwise it wont Work: http://support.microsoft.com/kb/2527494 ?

    See my overview here: http://erikej.blogspot.dk/2012/10/sql-server-compact-35-sp2-downloadable.html (8089 is only the server tools, but 8088 also includes a new device MSI / cab files)


    Please mark as answer, if this was it. Visit my SQL Server Compact blog

    Thursday, November 22, 2012 6:27 PM
    Moderator
  • Hi... Yes I am running 8088 on the device... I did discover what breaks it, it works great on a fresh SQL server 2012 install... But after installing SP1 (build 3000) it breaks it very badly, keeps looping and crashing the web process... Bugs me a little! Can you think of what they did to break it?
    Friday, November 23, 2012 12:11 AM
  • Is the IIS and SQL Server on the same box - if not, apply SP1 to both boxes.

    I wonder how much testing has been done with Server 2012? the 8088 hotfix is quite old. I would log a connect issue with detailed repro information. I would also try to install SP1 CU1.


    Please mark as answer, if this was it. Visit my SQL Server Compact blog

    Friday, November 23, 2012 6:48 AM
    Moderator
  • Applied CU1-->

    2012/11/23 10:00:58 == SQLCESA Version ==> 3.5.8089.0
    2012/11/23 10:00:58 Hr=80004005 ERR:Couldn't find existing RSCB 1

    no change--

    (IIS & SQL are on the same box)

    but how would I apply SP1 to a separate IIS box (where SQL is not installed)? I don't understand, never set it up that way--

    Friday, November 23, 2012 3:04 PM
  • OK, according to Alberto's post, this Works with Windows 8 Pro, so it should Work with Windows Server 2012 also.

    You can configure a setup with a separate IIS and SQL Server, but you must still install SQL Server replication components on the IIS box. (As apply any SP to these as well)

    Have a look at the installtion tips here, maybe they can help: http://erikej.blogspot.dk/2010/06/walkthrough-configuring-merge.html


    Please mark as answer, if this was it. Visit my SQL Server Compact blog

    Friday, November 23, 2012 3:56 PM
    Moderator
  • checked the event log & found:

    Faulting application name: w3wp.exe, version: 8.0.9200.16384, time stamp: 0x50108835

    Faulting module name: replrec.dll, version: 2011.110.3000.0, time stamp: 0x5081c2b2

    Exception code: 0xc0000005

    Fault offset: 0x0000000000059eff

    Faulting process id: 0x7d0

    Faulting application start time: 0x01cdc994d9d69c68

    Faulting application path: c:\windows\system32\inetsrv\w3wp.exe

    Faulting module path: c:\Program Files\Microsoft SQL Server\110\COM\replrec.dll

    Report Id: 17d435c7-3588-11e2-93ef-00155d1e2606

    Faulting package full name:

    Friday, November 23, 2012 4:10 PM
  • OK, according to Alberto's post, this Works with Windows 8 Pro, so it should Work with Windows Server 2012 also.

    You can configure a setup with a separate IIS and SQL Server, but you must still install SQL Server replication components on the IIS box. (As apply any SP to these as well)

    Have a look at the installtion tips here, maybe they can help: http://erikej.blogspot.dk/2010/06/walkthrough-configuring-merge.html


    Please mark as answer, if this was it. Visit my SQL Server Compact blog


    but did he try w/sql2012 sp1? -- per my prev. post, it works fine *before* applying sql2012 sp1
    Friday, November 23, 2012 4:13 PM
  • I think you need to raise a support issue, or at least report on connect. I will attempt to repro if I find time to do so.

    Please mark as answer, if this was it. Visit my SQL Server Compact blog

    Saturday, November 24, 2012 8:40 AM
    Moderator
  • Very odd, we have already tried with success the CU 7 with SQL Server 2012 on Windows Server 2008 and Windows 8 Pro, with a .NET CF 3.5 application with SQL Server Compact 3.5SP2 running on Windows Mobile devices.

    Alberto Silva Microsoft MVP - Device Application Development - http://msmvps.com/AlbertoSilva moving2u - R&D Manager - http://www.moving2u.pt

    Can you please apply sql2012 SP1 & try again...? that's causing the problem for me--

    I discovered it works fine *before* applying sql2012 SP1

    (also CU1 does not fix it)


    Wednesday, November 28, 2012 8:41 PM
  • I have now tested with 2012 SP1/CU1, and I am able to repro (getting same error as you are). Had to tweak replication share security and SQL Server Agent security to get this far. Did you post a connect item?

    The Client error is:

     Error Code: 80004005
     Message   : The IIS service is not available.
     Minor Err.: 28025
     Source    : Microsoft SQL Server Compact

    and the server agent log:

    2012/11/29 10:59:13 == SQLCESA Version ==> 3.5.8088.0
    2012/11/29 10:59:13 Hr=80004005 ERR:Couldn't find existing RSCB 1


    Please mark as answer, if this was it. Visit my SQL Server Compact blog


    Thursday, November 29, 2012 9:49 AM
    Moderator
  • Nice that you're able to repro--

    I've never done a connect item, do you want me to attempt it?--, or would one from you be more effective?

    Thanks!

    Thursday, November 29, 2012 7:06 PM
  • I am working on getting support for the issue. 

    Please mark as answer, if this was it. Visit my SQL Server Compact blog

    Thursday, November 29, 2012 8:14 PM
    Moderator
  • Right now I can't install SP1 on that VM because of some other tests we're making, but as soon as the VM is ready to destroy, we'll try with SP1. Anyway, I've just voted on Connect.


    Alberto Silva Microsoft MVP - Device Application Development - http://msmvps.com/AlbertoSilva moving2u - R&D Manager - http://www.moving2u.pt

    Wednesday, December 05, 2012 11:40 PM
  • Hi Erik,

    I see you tested it on server 2008r2 (& it works) -- I only tested it on server 2012, it's probably something with IIS 8.0

    Friday, January 18, 2013 5:53 PM
  • yes, the issue only occurs with sql 2012 SP1 with IIS 8

    Please mark as answer, if this was it. Visit my SQL Server Compact blog

    Friday, January 18, 2013 8:10 PM
    Moderator
  • I was just wondering if a solution to the problems with 2012 SP1 has been found? We have the exact same problem now and we even tried to patch with CU2 but still same issue with looping...

    Thanks

    Friday, March 15, 2013 12:14 PM
  • No, if you have a blocking producution issue, you can call support, according to the Connect item (have a look at it) - and if you get through, let use know ho it goes...

    Please mark as answer, if this was it. Visit my SQL Server Compact blog

    Friday, March 15, 2013 12:23 PM
    Moderator
  • SQL Server 2012 SP1 CU4 with a fix for this issue has just been released.

    Please mark as answer, if this was it. Visit my SQL Server Compact blog Windows 8 Apps Showcase

    Friday, May 31, 2013 7:49 PM
    Moderator
  • We have already tried in a SQL Server 2012 SP1 instance on Windows Server 2008R2 x64 and confirmed that the update mentioned by Eirk fixed the issue.

    Alberto Silva Microsoft MVP - Device Application Development - http://msmvps.com/AlbertoSilva moving2u - R&D Manager - http://www.moving2u.pt

    Wednesday, June 12, 2013 4:31 PM
  • Very cool!

    I'll test it out--

    Friday, August 02, 2013 2:58 PM
  • Hi All,

    I had same issue today with fresh install of SQL Server 2012 SP3 CU2 X64 on Windows Server 2012 Datacenter.

    SQL and IIS 8.0 are on same box and SSCEServerToolsX64 are 8109 version.

    I solved this problem by just installing SQL Server 2008R2 Clients Tools connectivity on the same box.

    Et voilà...

    Tuesday, April 19, 2016 3:03 PM