Step by step teach you how to configure SQL server merge and copy (3) Configure distributor

SQL Server distributorOne of its responsibilities is to process a snapshot folder containing the content of the published database. It gives iis the channel to read files from the shared folder you created. open the Resource Management window, expand my computer, and create a new SnapshotAs shown in (My suggestion is to create this folder in the system or SQL Server), Right-click the folder, and select Sharing and security.
( Note: because there are many images, I try to reduce the size of the image to speed up the transmission of the page. Therefore, the image display is not very clear, but it is definitely clear.)

ClickSharingTab, selectShare this folderAnd then clickPermissionsAs shown in:

In the displayed dialog box, clickAdd.

In the user search menu, clickLocationsThis button.LocationsIn this dialog box, expandEntire directoryThis node, selectSyncdomain. InternalThen clickOK. (Note:This is the domain discussed in the previous article. If the domain controller is not added, you can directly add a local user to the added user.) inEnter the object names to selectEnter the previously created domain users in this box.SyncuserAnd then clickCHECK NAMESClick to confirm the name and obtain a complete username (domain) format.

Go back to the permission menu and clickSync user, InChangeAndReadCheck the permission box and click OK.

Return to the first tab and selectSecurityClick this optionAdd.

After selecting a user and a groupEnter the object names to selectEnterSyncuser, ClickOK

Then select the newly added user and grant itRead&Execute,List folder ContentsAndReadAnd then selectOK.

Configure distribution:

Now that you have configured a snapshot folder, it is time to createDistributionOpen yourSQL Server, Right-clickReplicationAnd then selectConfigure Distribution, As shown in:

The first page is configure distributor wizard. Click Next directly:

In the selectDistributorOn this page, the first option is to use the local serverDistributor,The second option is to select another server. We select the first server and then clickNext.

InSnapshot folderOn this page, enter the path of the created snapshot folder and clickNext.

In the selectDistributor DatabaseIn this interface, if you are using a single server structure, you can select the default value and then clickNextBut for better file transmission performance, I suggest youDistributionThe database and its log files are separated into two disk partitions, just as I suggest you installSQL ServerThe folder where the snapshot is installed is located separately in different partitions.

InPubilsherThis interface lists the connections that have been configured.DistributorDatabasePublishersBy default, your local database server is displayed. ClickAddAnd then selectAdd SQL Server publisher.

Then you will be redirected to selectSQL ServerIn this example, enterSyncpublisherOf course, here you choose any availableSQL ServerServer, clickConncet.

After the connection is successful,PublishersThe newly addedSyncoublisherAdd this server. ClickNext.

When a remote SQL ServerPublisherAfter being added,Distributor PasswordThe interface will prompt you to enter a password to ensure that the remotePublisherAnd localDistributorThere is a management connection verification. We enter both the password and the password.P @ sswordAnd then clickNext.

InWizard actionsThere are two check box buttons on this interface. The first one is to complete this configuration, and the second one is to generate a script, in this case, if you want to perform the same configuration on other servers, simply execute this script. SelectGenerate a script file with steps to configure DistributionThen clickNext.

If you choose to generate a script in the previous interface, the next interface is to let you choose the location where the script file is stored.Script File PropertiesIn this interface, you can specify the location where the script is stored, whether to overwrite the script, and select the file format. Click Next.

InComplete the wizardOn this page, you can see the overall situation you configured earlier. You can copy this information, because there are too many paths and sometimes it is too difficult to remember. ClickFinish.

InProcessing...In this interface, we can see a series of configuration processes, if all are promptedSuccessYou can clickCloseAnd if all the configurations areSuccess, IgnoreMessageInCompleted with errorsBecause it is an error.

Check whether the configuration is complete. Open yourSQL Server, ExpandDatabasesAndSystem databasesFolder. If the above configuration is complete, you will see a newly createdDistributionDatabase.

Okay, here we are.DistributorThe configuration is complete.