Click here to Skip to main content
Click here to Skip to main content

Install and Configure SQL Server for SQLCE replication

, 13 Sep 2003 CPOL
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

Introduction

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.

Note

  • 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

Steps

  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

License

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

Share

About the Author

No Biography provided

Comments and Discussions

 
GeneralRelated SQLCE article PinmemberSamuel Allen26-May-08 19:03 
QuestionRe: Related SQLCE article Pinmember123erich12325-Sep-08 0:57 
GeneralSQL Server (CE) 2000 SP4... download here PinmemberChristopher Scholten15-Jul-05 23:41 
GeneralStrange linking errors PinmemberAlex Evans2-Oct-04 23:00 
GeneralSQL CE does install over SP3 Pinmembertetsuo11923-Jun-04 10:38 
Generalplease elaborate !! Pinmemberdharani23-Mar-04 17:59 
GeneralRe: please elaborate !! PinsussAnonymous23-Mar-04 20:04 
GeneralSQLCE will not install over SP3... PinmemberJoão Paulo Figueira15-Sep-03 12:07 
GeneralRe: SQLCE will not install over SP3... PinmemberDoophus15-Sep-03 12:12 

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

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

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