Solved

Replication MS SQL CE

Posted on 2004-10-04
10
368 Views
Last Modified: 2012-05-05
I want to set up Replication in this environment:
Sql SERVER CE clients (handheld devices - PocketPCs), WebServer running IIS, SQL Server machine running MS SQL and beeing the publisher!

can somebody step me through the process. I've never done this before and am slightly confused about it right now.
thanks beforehand.
kind regards, Martin.
0
Comment
Question by:Artform04
  • 6
  • 4
10 Comments
 
LVL 13

Accepted Solution

by:
danblake earned 500 total points
ID: 12216797
Here is a hint...

http://beta.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20981170.html
http://beta.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20908851.html

There are many types of replication available, you will need to be a little bit more specific -- but the above link gives information on this.
0
 
LVL 1

Author Comment

by:Artform04
ID: 12217367
I looked at all the articles on here. unfortunatelly I didnt find anything very relevant

Basically I'd like to set up merge replication:
In a two servers environment, where I guess I would do the following:
place IIS on one server and configure the SQL Server Publisher and Distributor on another server. The server running IIS can be isolated from the Internet by a firewall. SQL Server CE clients, running on Windows CE-based devices, synchronize by connecting to IIS. Another firewall can isolate the SQL Server Publisher and Distributor from the IIS system.

How do I set up the IIS on one server which gets the data from the SQL serverPublisher and distributor on another server.

martin.
0
 
LVL 1

Author Comment

by:Artform04
ID: 12217502
In the environment described above;

When in the create Publication wizard, I'm asked;
Make <<server>> its own distributor or Select a server to be the distributo - should I make myServer its own distributor?

When I do this the following message gets thrown at me:
"SQL Server Agent on '<<server>>' currently uses the system account, which causes replication between servers to fail. In the following dialog box, specify another account for the Service startup account.

I'm a little puzzled from this.
kind regards,
0
 
LVL 13

Expert Comment

by:danblake
ID: 12217538
This is because you are using the local system account for your sql-server agent... This does not have network permissions which replication requires...

Have a look at: http://support.microsoft.com/default.aspx?scid=kb;en-us;321822
HOW TO: Replicate Between Computers Running SQL Server in Non-Trusted Domains or Across the Internet
0
 
LVL 13

Expert Comment

by:danblake
ID: 12217553
SQL Server Replication does not use IIS.
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 13

Expert Comment

by:danblake
ID: 12217615
Have a look here for some detailed setup information ...

http://www.databasejournal.com/features/mssql/article.php/1438231

This gives some more account permissions, the how-to article is for your more advanced setup.
0
 
LVL 1

Author Comment

by:Artform04
ID: 12235572
I carried through some installations, IIS will be used thought, I think I didnt explain myself very well.
I'll reexplain:

An Internet Server API (sscesa20.dll), called the SQL Server CE Server Agent, is installed on my IIS server. That agent communicates both with the SQL Server CE Client Agent, which runs on the Windows CE device and the SQL Server 2000 publisher which runs on the server machine.

I'm setting up basic authentication for IIS. I'll also created a new folder on the server machine which I made shareable, so IIS user can access it.
(Right now my IIS is behind a firewall and the shared folder is not accessible from IIS.)
So that is my situation right now.

Could you please point out any important points I need to carefully take care off, keeping in mind I have nearly no experience with user-accounts, etc... (I am mainly a programmer) perhaps a few steps from here.


0
 
LVL 13

Expert Comment

by:danblake
ID: 12235652
I will repeat this only once more, IIS is not used anywhere or any API for the replication parts of SQL-Server CE / SQL Server 2000.
IIS API may be used if you are creating a web-interface for your clients, the Replication does not rely on a client-interface and is setup/managed using Enterprise Manager / Query Analyser.

I do not understand why you are giving me IIS setup information, I'm not going to tell you how to build a web-site using SQL Server as a back-end as this is not the question asked unless you are after something that is not replication.  I have explained sql-sever replication for you... given you the steps you require to setup the replication, what is the problem ?
0
 
LVL 1

Author Comment

by:Artform04
ID: 12235746
I asked the following question:
I want to set up Replication in this environment: Sql SERVER CE clients (handheld devices - PocketPCs), WebServer running IIS, SQL Server machine running MS SQL and beeing the publisher!
can somebody step me through the process.

I've clearly said setting up replication in that environment. I received something quite different.
I'll give you the points because I don't have time for this.
kind regards,
Martin
0
 
LVL 13

Expert Comment

by:danblake
ID: 12235774
I think that you are not understanding the purpose of this site.  IT is for people to offer advice, not do somebodys job for them -- sometimes they will point you in the right direction and give you all the information you need -- this needs to be digested and understood because blindly following instructions leads to a lack of understanding in many areas such as security of replication.  If you have a look through my PAQs you will see that I have managed to guide people to setup replication using SQL CE Edition pointing them at various other articles and offering assistance in the process. You have just come back and said the components you wish to use for replication which your enviroment contains, which is fine. I have given the instructions that are required for replication to be setup..

If you do not understand where to place your distributor that is concerning, it is a decision you have to make.  There are many reasons why you may have it on the same server or a different one -- that you will decide upon a number of factors that is important in your enviroment.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MySQL 5.6 or MariaDB 15 73
Link Quickbooks point of sale to server 12 79
SQL Insert Query Help 16 86
MSSQL Convert Char To Date 4 43
In today’s complex data management environments, it is not unusual for UNIX servers to be dedicated to a particular department, purpose, or database.  As a result, a SAS® data analyst often works with multiple servers, each with its own data storage…
Read about achieving the basic levels of HRIS security in the workplace.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now