Click here to Skip to main content
13,048,584 members (90,955 online)
Click here to Skip to main content
Add your own
alternative version


36 bookmarked
Posted 13 Sep 2003

Install and Configure SQL Server for SQLCE replication

, 13 Sep 2003
Rate this:
Please Sign up or sign in to vote.
After pulling my hair out for several days I finally figured out how to install and configure SQLCE with SQL Server for replication to a Windows CE device. I hope this saves you some pain


Let me start by saying that I'm not a SQL guru, I'm not a DBA, I'm a lowly application programmer who just happens to (begrudgingly) need to use SQL server. I thought I was fairly adept and figuring out weird combinations of software until I tried to install SQL Server CE and set it up to replication with my SQL Server on the desktop.

SQLCE and SQL Server, they are supposed to work together, right? They do but there are a few gotchas along the way that you might like to know about. I look forward to hearing other tips or advice on this process.

The instructions

It's pretty simple actually but you have to do it exactly as follows.


  • SQLCE (Server Tools) will not install without SP1 it will not install with SP3. You must install SQL2k -> SQL2KSP1 --> SQLCE --> SQL2KSP3
  • SQL Replication will not work if the SQL service is running under the system account. You MUST configure the SQL services to use a DOMAIN account with 'run as service' privilege


  1. Run SQL 2K Installer.
  2. Change the Instance Name
  3. Do NOT use the System account. It does not work for replication.
  4. The account you use must run as a service
  5. The account must have a password
  6. change the sa password
  7. Install SP1. DO NOT install SP3 yet. SQLCE will not install over SP3
  8. Now Install SQLCE
  9. Now Install SP3


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

No Biography provided

You may also be interested in...


Comments and Discussions

GeneralRelated SQLCE article Pin
Samuel Allen26-May-08 18:03
memberSamuel Allen26-May-08 18:03 
QuestionRe: Related SQLCE article Pin
123erich12324-Sep-08 23:57
member123erich12324-Sep-08 23:57 
GeneralSQL Server (CE) 2000 SP4... download here Pin
Christopher Scholten15-Jul-05 22:41
memberChristopher Scholten15-Jul-05 22:41 
GeneralStrange linking errors Pin
Alex Evans2-Oct-04 22:00
memberAlex Evans2-Oct-04 22:00 
GeneralSQL CE does install over SP3 Pin
tetsuo11923-Jun-04 9:38
membertetsuo11923-Jun-04 9:38 
Generalplease elaborate !! Pin
dharani23-Mar-04 16:59
memberdharani23-Mar-04 16:59 
GeneralRe: please elaborate !! Pin
Anonymous23-Mar-04 19:04
sussAnonymous23-Mar-04 19:04 
GeneralSQLCE will not install over SP3... Pin
João Paulo Figueira15-Sep-03 11:07
memberJoão Paulo Figueira15-Sep-03 11:07 
GeneralRe: SQLCE will not install over SP3... Pin
Doophus15-Sep-03 11:12
memberDoophus15-Sep-03 11:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170713.1 | Last Updated 14 Sep 2003
Article Copyright 2003 by Garth Tissington
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid