Step by step teach you how to configure SQL server merge and copy (2) create a domain user

In the following sections, I will introduce how to build a synchronization system that can meet the needs of the world's largest mobile industry applications, you will find that it can be used as a tool book instead of just a theoretical exercise. I will not waste your time building some theoretical concepts, you have a chance to roll up your sleeves.

The following is a domain called syncdomain. in this domain, a user named syncdc is created, an IIS server named syncweb, and an SQL server named syncpublisher, an SQL Server distributor is called syncdistributor. these are created to complete this book and give you a complete process of configuring this system. In the following sections, you will see that the above names appear frequently throughout the entire section.
In the remaining sections, I will teach you how to create a domain user and restore a downloaded database. This database is a sample database that provides the merge copy function.

In the second section, I will take you to configure a distributor, which starts from creating a snapshot folder. Then, you will use the release Configuration Wizard to securely create a database for publishing and replication and establish a connection with it. Of course, I will also show you how to disconnect the services you provide, and finally teach you how to improve the performance of the Publishing Server through a few small examples of experiments.

In the third section, I will teach you how to configure the very core publisher in the synchronization system. You will select some tables, columns, and some queries according to the new copy wizard, let the client synchronize only the corresponding tables and columns. Here, I will still demonstrate several tools to monitor the published replication service, so that you can solve it very quickly in case of a sudden occurrence.

In section 4, I will take you to configure an IIS server and Install SQL server tools. You will create a virtual directory on IIS according to the Web Synchronization Wizard. At last, I will teach you how to protect IIS processes, reduce memory consumption, and then adjust your web server to achieve better performance.

The fifth section is for those who use C # And. Net compactframework 2.0. Here we will teach you how to use code to synchronize server data in the device.

It seems a lot of nonsense. Okay, let's start the first configuration now.

Create a domain user:(Translator's note: If you think the process of creating a domain is too cumbersome, you can skip this step and directly use the local users on the server, the main purpose of establishing a domain is to enhance the security of the system ):

The use of the domain can bring great security assurance to our synchronization system. When data is synchronized ,. the managed code on net compactframework sends the user name and password in the domain to the server to verify whether the server has the permission to synchronize data. The server verification also includes IIS and SQL Server, this is enough to improve the security of the entire system and prevent external intrusion. The following describes how to create a domain user, which will be encountered in the following configuration. First, log on to your domain controller and selectAll programs | Administrative ToolsClickActive Directory users and computers, As shown in:

WhenActive Directory users and computersAfter the menu is opened, expandSyncdomain. InternalClickComputersThis node, then you will seeSyncdistributor, syncpublisherAndSyncwebShows the members in these domains:

Right-clickUsersNode, and then selectNew | user, As shown in:

A new user page will pop up.First nameEnterSync, InLast nameInputUser,User Logon NameInputSyncuser, As shown in, and then clickNext

InNew object-userInPasswordAndConfirm PasswordAll inputP @ ssword, Only hookPassword Never ExpiresAnd then clickNext.

A confirmation dialog box will pop up to confirm that the information displayed in the dialog box is consistent with the information you entered, and then clickFinishThe domain user is created.