Click here to Skip to main content
2,075 members
Articles / Multimedia / C++
Article

Install and Configure SQL Server for SQLCE replication

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
12 Apr 2012CPOL 7.5K  
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)


Written By
Canada Canada
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
-- There are no messages in this forum --