1: the Environment
Server environment:
Machine Name: ZEHUADB (MSSQL)
Operating system: Windows Server
Database version: SQL Server SP4 Personal Edition
Client
Machine Name: ZLP (DANDAN)
Operating system: Windows XP
Database version: SQL Server SP4 Personal Edition
2: Build user account
Create a user account on the server side
My Computer Management-> Local Users and Groups-> user-> Build
Username:zlp
Userpwd:zlp
3: Reboot the server MSSQLServer
My Computer-> control face version-> management tools-> Service->mssqlserver Service
(Change to: User account, our new ZLP user. \ZLP, password: ZLP)
4: Installing the Distributor
A: Configuring the Distributor
Tools-> Replication-> Configure Publishing, subscribers, and distribution-> next-> next (all with default configuration)
B: Configuring the Publisher
Tools-> Replication-> Create and manage Publications-> Select the database to publish (SZ)-> next-> Snapshot publishing-> next->
Select what to publish-> next-> next-> next-> finish
C: Force configuration Subscriber (push mode, pull mode is similar to this)
Tools-> Replication-> Configure Publishing, subscribers, and distribution-> subscribers-> Create a new->sql server database-> Enter a client server name (ZLP)-> Use SQL Server Authentication (SA, blank password)- > Determine-> application->
D: Initializing Subscriptions
Replication Monitor-> Publisher (ZEHUADB)-> Double-click Subscription-> Force new-> next-> Select Enabled Subscribers->zlp->
Next-> next-> next-> next-> complete
5: Test configuration is successful
Replication Monitor-> Publisher (ZEHUADB)-> double-click sz:sz-> Point State-> point to run Agent now
View:
Replication Monitor-> Publisher (ZEHUADB)->sz:sz-> Select Zlp:sz (type coercion)-> right mouse button-> start synchronous processing
If there is no error sign (Red Fork), congratulations on your configuration success
6: Test Data
Execute on server:
Select a table to execute the following SQL
INSERT INTO wq_newsgroup_s Select "Test Succeeded", 5
Replication Monitor-> Publisher (zehuadb)->sz:sz-> snapshot-> boot Agent
->zlp:sz (forced)-> start synchronous processing
To see if the sync wq_newsgroup_s inserted a new record