install/configure SQL Server 2000, SQL Server CE for merge replica

I cannot for the life of me figure out how to connect to my SQL database and
import it into a pocket pc. I've tried so many different settings and
configurations that I don't know where I am going wrong. I've been trying to
connect to the database from a Pocket PC 2002 emulator. I'm able to view the
sscesa20.dll from the emulator and that's about as good as it gets. But I
keep getting these errors:

Initializing SQL Server Reconciler has failed
The process could not connect to Distributor
SQL Server does not exist or access denied OR Login Failed for user


CLIENT SIDE:
I'm using C# to try and connect to the DB and below is the code I'm using to
try and sync the database, you can match these against the SERVER SIDE data
below:

ssceConn = new SqlCeConnection();
replication = new SqlCeReplication();

replication.Publisher = "VIT\VIT";
replication.PublisherLogin = "VIT\sa";
replication.PublisherPassword = blank;
replication.InternetUrl = "http://67.55.64.211/Northwind/sscesa20.dll";;
replication.InternetLogin = "VIT\IUSR_VIT";
replication.InternetPassword = "mypassword";
replication.Subscriber = "Northwind";
replication.Publication = "NorthwindProducts";
replication.PublisherDatabase = "Northwind";
strDataSource = "\NorthwindDB.sdf";
ssceConn.ConnectionString = "Data Source =" + strDataSource;
replication.SubscriberConnectionString =
"Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=" + strDataSource;

replication.Synchronize();



SERVER SIDE:
I've listed the steps below what I've been doing to try and get this to
work. I might be doing things out of order or I'm forgetting steps, so
please critique my steps taken:

Installation Steps:
1) Install Windows Server 2003
a) computer name: VIT
2) Install IIS 6
3) Install SQL Server 2000 Dev edition.
a) Installation Definition: Server and Client Tools
b) Instance Name: VIT
c) Service Settings: Use a Domain User Account
d) Authentication Mode: Mixed Mode; and I left the sa password
blank for now.
4) Installed SQL Server 2000 Service Pack 3a
5) Installed SQL Server CE 2.0 Server Tools for Service Pack 3a

Configuration Steps:
1) Database Login for SQL Server Enterprise Manager:
a) Created a new login account for VIT\IUSR_VIT in the VIT\VIT
SQL Server Group
b) General Tab: Selected Windows Authentication, Domain VIT,
Database: Northwind.
c) Database Access Tab: Check Permit box for Northwind Database
with user IUSR_VIT

Create Snapshot folder steps:
1) Create folder C:\Snapshot
2) Share the folder as "MySnapshot"
3) Set Permissions to allow everyone read and write permissions.

Create publication Steps:
1) In SQL Server Enterprise Manager's Microsoft SQL Servers->SQL Server
Group->VIT\VIT->Replication->Publication folder.
2) Right click Publication and select New Publication, the wizard starts.
a) Select option: Make 'VIT\VIT' it's own Distributor.
b) Select option: Yes, configure the SQL Server Agent Service to
Start Automatically.
c) Snapshot folder: \\VIT\MySnapshot
d) Publication Database: Northwind
e) Publication type: Merge publication
f) Subscriber Type: Device running SQL Server CE
g) Specify Articles: I just chose the Products Object.
h) Articles Issues: Uniqueidentifier columns will be added to
tables.
i) Publication Name: NorthwindProducts
j) Properties of Publication: No, Create the publisher as
specified.

Configure permissions for publication steps:
1) In SQL Server Enterprise Manager's Microsoft SQL Servers->SQL Server
Group->VIT\VIT->Replication->Publication->NorthwindProducts
2) Right click Northwind and select properties:
a) Publication Access List tab: Add User VIT\IUSR_VIT

Configure IIS steps (fyi: I'm doing this manually because when I use the
SQL Server CE Wizard, it puts the virtual directory under the wrong webpage):
1) Create new folder: C:\NorthwindCE
2) Copy and paste sscesa20.dll into that folder.
3) Start IIS 6.0
4) Right click my web site and select New->Virtual Directory.
a) Alias: Northwind
b) Path: C:\NorthwindCE
c) Permissions: Read, Execute, Write, Browse. (These are set
to this just for testing, so I can see if I can browse the folder from IE)
5) Right Click the new virtual directory, NorthwindCE and click properties.
a) Directory Security Tab-> Authentication and access control->
Edit: Enable Anonymous Access.
b) User: VIT\IUSR_VIT
c) Password: mypassword
6) Register sscesa20.dll

Double check Windows Server 2003 configurations:
1) Services:
a) Make sure that MSSQL$VIT service starts automatically and
that it's set to a windows account and not local system.
a) Make sure that SQLAgent$VIT service starts automatically and
that it's set to a windows account and not local system.

Double check SQL Server Enterprise manager configuration:
1) VIT\VIT Server properties
a) Security tab: Make sure SQL Server and Windows
Authentication is selected.
2) NorthwindProducts:Northwind Publicatio properties
a) Snapshot location: Make sure it's set to \\VIT\MySnapshot

That's basically all the steps that I've taken to try and get this to work.
This is all new to me, I've never developed in C# and I've never used SQL
Server, so please point out all my beginner mistakes and things I might have
over looked. Oh, one more thing, the client side is being done on a Windows
XP box with Visual Studio .NET 2003. And the server is a seperate box
running everything else, Windows Server 2003, SQL Server 2000, SQL Server CE
2.0, and IIS 6.0.

Thanks for taking the time to read all of that, I hope this will be a simple
solution....however, I doubt it. Have a good one!

Steven808
.

Relevant Pages

  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... MSDE to store SharePoint uses the MSSQL$SharePoint database, ... SharePoint named instance to full SQL. ... You cannot upgrade the Monitoring instance to SQL ... What I see is the SQL server group and under ...
    (microsoft.public.windows.server.sbs)
  • Re: Using Access 2007 to connect to SQL
    ... MDB database file format, ODBC linked tables, passthrough queries ... probably the easiest way of retrieving data from a SQL-Server ... I'm a total newbie w MS SQL Server. ...
    (microsoft.public.access.adp.sqlserver)
Loading