Distributed Replay controller and client setup


1. Install SQL Server components for Distributed Replay

dreplaysql

2. In case you missed the wizard steps to configure DReplay Controller and Client, configure it through the configuration files.
    a. Controller: C:\Program Files (x86)\Microsoft SQL Server\120\Tools\DReplayController\DReplayController.config
    b. Client: C:\Program Files (x86)\Microsoft SQL Server\120\Tools\DReplayClient\DReplayClient.config

3. Configure the Windows firewall on the Distributed Replay Controller to allow inbound connection for DReplayController.exe application.

4. To verify-
    a. Run NET STOP “SQL Server Distributed Replay Controller”
    b. Run NET START “SQL Server Distributed Replay Controller”
    c. Check Dreplay Controller’s log files to verify success: C:\Program Files (x86)\Microsoft SQL Server\110\Tools\DReplayController\log

5. Follow steps in this page to configure the Controller machine and Child machines: https://msdn.microsoft.com/en-us/library/ff878359.aspx

6. Configure the Dreplay Client
    a. NET STOP “SQL Server Distributed Replay Client”
    b. NET START “SQL Server Distributed Replay Client”
    c. Check the Dreplay Client’slog files to verify successful registration with Controller: C:\Program Files (x86)\Microsoft SQL Server\110\Tools\DReplayClient\log

7. If access is denied to the controller, configure Distributed COM users with dcomcnfg
    a. On the server where controller is installed. Go to Start > Type dcomcnfg > Press Enter
    b. In dcomcnfg, navigate to Console Root > Component Services > Computers > My Computer –> DCOM Config -> DReplayController
    c. Open the properties of DReplayController and select Security tab
    d. Edit “Launch and Activation Permissions” and grant “Distributed Replay client service account” permission for “Local Activation” and “Remote Activation”.
    e. Edit “Access Permissions” and grant “Distributed Replay client service account” permission for “Local Access” and “Remote Access”.
    f. Add “Distributed Replay client service account” domain user account within “Distributed COM Users” group.
    g. Restart controller and client services like below
      NET STOP “SQL Server Distributed Replay Controller”
      NET STOP “SQL Server Distributed Replay Client”
      NET START “SQL Server Distributed Replay Controller”
      NET START “SQL Server Distributed Replay Client”
    h. Check the Distributed Replay Client log file and see the message “Registered with controller <controller name>”

Skip to main content