Click here to Skip to main content
971 members (175 online)
Click here to Skip to main content
Add your own
alternative version

Stats

2.3K views
Posted 12 Apr 2012

Install and Configure SQL Server for SQLCE replication

, 12 Apr 2012
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

This member doesn't quite have enough reputation to be able to display their biography and homepage.

You may also be interested in...

Comments and Discussions

 
-- There are no messages in this forum --
Permalink | Advertise | Privacy | Terms of Use | Mobile
RA-Web1 | 2.8.171114.1 | Last Updated 12 Apr 2012
Article Copyright 2012 by Garth Tissington
Everything else Copyright © RootAdmin, 1999-2017
Layout: fixed | fluid