Preparing for SQL Server Replication

Before SQL Server replication can be configured, complete several pre-configuration steps to ensure that the deployment servers are correctly configured.

To prepare for SQL Server replication on the master deployment server

1. Create a folder to store the database snapshots, and then configure the folder as a share.

Note For more information about securing the snapshot folder, see Securing the Snapshot Folder.

2. Ensure that the SQL Server Browser service is enabled and set to Automatic.

3. In the SQL Server Surface Area Configuration box, click Local and Remote connections.

To prepare for SQL Server replication on the child deployment server

1. In the SQL Server Surface Area Configuration box, click Local and Remote connections.

2. Optionally, create an empty database to host the replicated MDT DB.

Note This database must be given the same name as the MDT DB on the master deployment server. For example, if the MDT DB on the master deployment server is called MDTDB, create an empty database called MDTDB on the child deployment server.