SQL Server 2000 replication synchronization Configuration and FAQs

SQL Server 2000 replication synchronization Configuration and FAQs (top)

Recently, due to the use of SQL Server2000 synchronous replication, the configuration of a distribution, publisher and Subscriber synchronization between the database, which also encountered a number of problems, eliminating the theoretical explanation, highlighting the configuration steps and problem solving, is summarized as follows:

Environment Configuration requirements:

SQL Server 2000 needs to hit the SP4 patch, patches can go online search, address a lot, then how to determine whether the SP4 patch hit it?

Open Query Analyzer, type the SQL statement "SELECT @ @version" and press F5 to execute if the result is displayed

Microsoft SQL Server 2000-8.00.2039 indicates that the SP4 patch was successful.

(i) Distribution, release server-side environment configuration and issues

1. Create a new user in the Control Panel user account belonging to administrators

Here the user name is Admini

Create an Account

You can see the account you just created under administrators in Computer Management after you create it

2. Create a password for the account you just created (must)

Password any, here is 123

3, change the SQL Service login account for the newly created administrator user, format (note that the length of the password shown here does not represent the actual password length)

Issue 1: If the user name password is incorrectly configured here, the following error will be encountered when starting the service:

4. Create a new SQL Server registration in Enterprise Manager

Issue 2: Selecting SQL Authentication here will cause the last user logon failure error, such as:

Go on:

You can see that you have successfully registered to the Administrator Admini account here is a brief explanation of why you must register with the newly created administrator user, log in, and use the local account?

Issue 3: If the server is registered with local locally, the boot the Configure publishing, subscriber, and distribution wizards encounter the following prompts to make the wizard unable to continue. At the same time, establishing a unified Windows login account can facilitate the configuration of each computer in the network. 5. Create a snapshot shared folder

Create a folder on disk that Admini users have full control of, folder pub here Issue 4: Why do I not have permission buttons for sharing settings? The reason is that simple file sharing is turned on, and its check box is canceled in the folder OptionsAt this point, the server-side configuration of the release, subscribers and pre-distribution of the environment before the completion of the work, the rest of the next day to write, write not move. SQL Server 2000 replication synchronization configuration and frequently asked questions (below)

(ii) Distribution, release of server-side configuration and issues

1. Start the configuration publication, subscribe to the service area, and the Distribution Wizard

2. Specify the snapshot shared folder on the network location







3. Complete configuration

4. Start the New Publication Wizard



5. Select the database to publish

6, select Merge publication, so that no matter which end of the data changes will be full range synchronization

7, here can choose to compatible with the old version of SQL Server, the default is only 2000

8. Select the objects in the database you want to publish

9.

11. Set New Publication properties

12. Tick "Allow anonymous subscription"

Question five: If "Allow anonymous subscription" is not checked here, there will be an error in the subscription configuration:

The publisher configuration is complete, of course, some of them do not go absolutely, according to the actual situation, such as the way to publish.

13. Create a new pull subscription

14, add the Publisher, the Publisher is best to define here, or there may be publishing items can not display problems



15. Using SQL Server for authentication

16. Select the database to publish



17, generally if you back up the restored database, rather than import the exported Data migration mode, select No

18, according to the requirements of the selection of synchronization task scheduling







19, the configuration is complete, at this time can verify the two libraries are synchronized, new data to query.

SQL Server 2000 replication synchronization Configuration and FAQs