SQL Server – Distributed Replay :- Component Services Configuration

 

Background

It is a good practice to review Windows Event Viewer upon installing new products and also as part of ongoing maintenance.

 

Installing

For this post we will do so as we familiarize ourselves with SQL Server’s Distributed Replay toolset.

Trouble Shooting

Event Viewer

Images

Windows Logs – System

Image – List Events

SQLServerDistributedReplayController.launchAndActivation.01.EventViewer.20190625.0336AM.PNG

Image – Detail Event

Image – Detail Event – Replay Controller

eventViewer.SQLServerDistributedReplayController.20190625.0440PM.PNG

Image – Detail Event – Replay Client

eventViewer.SQLServerDistributedReplayClient.20190625.0837AM.PNG

SERVICES

SQL Server Distributed Replay Controller

Text

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{D63B10C5-BB46-4990-A94F-E40B9D520160}
and APPID
{9CA88EE3-ACB7-47C8-AFC4-AB702511C276}
to the user NT SERVICE\SQL Server Distributed Replay Controller SID (S-1-5-80-1337333740-2787872843-2774717225-1767203911-559312492) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.

Explanation

  1. Issue :- Does not have Local Activation permission
  2. CLASS ID :- D63B10C5-BB46-4990-A94F-E40B9D520160
  3. APPID :- 9CA88EE3-ACB7-47C8-AFC4-AB702511C276
  4. User :- NT SERVICE\SQL Server Distributed Replay Controller SID (S-1-5-80-1337333740-2787872843-2774717225-1767203911-559312492)
  5. Source Computer :- Localhost
  6. Using :- LRPC ( Local RPC )

SQL Server Distributed Replay Client

Text

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{D63B10C5-BB46-4990-A94F-E40B9D520160}
 and APPID
{9CA88EE3-ACB7-47C8-AFC4-AB702511C276}
 to the user NT SERVICE\SQL Server Distributed Replay Client SID (S-1-5-80-3249811479-2167633679-2115734285-1138413726-166979568) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.

Explanation

  1. Issue :- Does not have Local Activation permission
  2. CLASS ID :- D63B10C5-BB46-4990-A94F-E40B9D520160
  3. APPID :- 9CA88EE3-ACB7-47C8-AFC4-AB702511C276
  4. User :- NT SERVICE\SQL Server Distributed Replay Client SID (S-1-5-80-3249811479-2167633679-2115734285-1138413726-166979568)
  5. Source Computer :- Localhost
  6. Using :- LRPC ( Local RPC )

Remediation

Outline

  1. Services
    • The List of Services are :-
      • SQL Server Distributed Replay Controller
      • SQL Server Distributed Replay Client
    • Please access the Services applet and get the Service Account
    • Get the following information
      • Accounts that Services are running under
      • Service Folder
  2. Component Services
    • Launch Component Services
      • Navigate to “Console Root” \ “Component Services” \ Computers \ “My Computer” \ “DCOM Config” branch
      • Select “DReplayController”
      • Right click on the component
      • Select Properties
      • Access “Security” Tab
        • Access the “Launch and Activation Permissions” group box
          • Ensure that the “Customize” option is selected
          • In the “Launch and Activation Permission” window
            • Grant the “NT Service\SQL Server Distributed Replay Client” principal the following permissions
              • Local Launch
              • Remote Launch
              • Local Activation
              • Remote Activation
            • Grant the “SQL Server Distributed Replay Controller” principal the following permissions
              • Local Launch
              • Remote Launch
              • Local Activation
              • Remote Activation
      • Access the “Access Permissions” group box
        • Ensure that the “Customize” option is selected
        • In the “Launch and Activation Permission” window
          • Grant the “NT Service\SQL Server Distributed Replay Client” principal the following permissions
            • Local Access
            • Remote Access
          • Grant the “SQL Server Distributed Replay Controller” principal the following permissions
            • Local Access
            • Remote Access
  3. Restart Services
    • Stop the “SQL Server Distributed Replay Client” service
    • Stop the “SQL Server Distributed Replay Controller” service
    • Restart the “SQL Server Distributed Replay Controller” service
    • Restart the “SQL Server Distributed Replay Client” service
  4. Review Services Log
    • SQL Server Distributed Replay Controller
      • Review”SQL Server Distributed Replay Controller” Log Folder
    • SQL Server Distributed Replay Client
      • Review”SQL Server Distributed Replay Client” Log Folder

Tasks

Component Services

Component – DReplayController Properties

Tab – Security – Launch and Activation Permission
Initial

SQLServerDistributedReplayController.launchAndActivation.01.20190625.0334AM.PNG

Post Changes

SQLServerDistributedReplayController.launchAndActivation.02.20190625.0336AM.PNG

Tab – Security – Launch and Activation Permission
Initial

SQLServerDistributedReplayController.access.01.20190625.0341AM.PNG

Post Changes

SQLServerDistributedReplayController.access.02.20190625.0336AM.PNG

Review Services Log

DReplayController

DReplayController Log
Image

DReplayControllerLog.20190625.0402PM.png

Textual

2019-06-24 14:19:52:868 OPERATIONAL [Controller Service] Microsoft SQL Server Distributed Replay Controller - 15.0.1300.359.
2019-06-24 14:19:52:888 OPERATIONAL [Controller Service] © Microsoft Corporation.
2019-06-24 14:19:52:889 OPERATIONAL [Controller Service] All rights reserved.
2019-06-24 14:19:52:997 OPERATIONAL [Controller Service] Current edition is: [Enterprise Evaluation Edition].
2019-06-24 14:19:53:000 OPERATIONAL [Controller Service] The number of maximum supported client is 16.
2019-06-24 14:19:53:001 OPERATIONAL [Controller Service] Windows service "Microsoft SQL Server Distributed Replay Controller" has started under service account "NT Service\SQL Server Distributed Replay Controller". Process ID is 8792.
2019-06-24 14:19:53:003 OPERATIONAL [Controller Service] Time Zone: Pacific Standard Time.
2019-06-24 14:19:53:013 OPERATIONAL [Common] Initializing dump support.
2019-06-24 14:19:53:014 OPERATIONAL [Common] Failed to get DmpClient. [HRESULT=0x8007007F]
2019-06-24 17:53:37:589 OPERATIONAL [Controller Service] Windows service "Microsoft SQL Server Distributed Replay Controller" is stopping...

Explanation
  1. Edition
    • Current edition is: [Enterprise Evaluation Edition].
  2. Max Supported Client
    • The number of maximum supported client is 16.

DReplayClient

DReplayClient Log
Image

DReplayClientLog.20190625.0409PM

Textual

2019-06-25 08:37:49:929 OPERATIONAL  [Client Service]      Microsoft SQL Server Distributed Replay Client - 15.0.1300.359.
2019-06-25 08:37:49:930 OPERATIONAL  [Client Service]      © Microsoft Corporation.
2019-06-25 08:37:49:931 OPERATIONAL  [Client Service]      All rights reserved.
2019-06-25 08:37:49:936 OPERATIONAL  [Client Service]      Current edition is: [Enterprise Evaluation Edition].
2019-06-25 08:37:49:940 OPERATIONAL  [Common]              Initializing dump support.
2019-06-25 08:37:49:941 OPERATIONAL  [Common]              Failed to get DmpClient. [HRESULT=0x8007007F]
2019-06-25 08:37:49:943 OPERATIONAL  [Client Service]      Windows service "Microsoft SQL Server Distributed Replay Client" has started under service account "NT Service\SQL Server Distributed Replay Client". Process ID is 10812.
2019-06-25 08:37:49:946 OPERATIONAL  [Client Service]      Time Zone: Pacific Standard Time.
2019-06-25 08:37:49:949 OPERATIONAL  [Client Service]      Controller name is "LAB".
2019-06-25 08:37:49:951 OPERATIONAL  [Client Service]      Working directory is "E:\Program Files (x86)\Microsoft SQL Server\150\Tools\DReplayClient\WorkingDir".
2019-06-25 08:37:49:952 OPERATIONAL  [Client Service]      Result directory is "E:\Program Files (x86)\Microsoft SQL Server\150\Tools\DReplayClient\ResultDir".
2019-06-25 08:37:49:953 OPERATIONAL  [Client Service]      Heartbeat Frequency(ms): 3000
2019-06-25 08:37:49:954 OPERATIONAL  [Client Service]      Heartbeats Before Timeout: 3
2019-06-25 08:37:49:989 OPERATIONAL  [Client Service]      Registered with controller "LAB".

Explanation
  1. Version
    • 2019-06-25 08:37:49:929 OPERATIONAL [Client Service] Microsoft SQL Server Distributed Replay Client – 15.0.1300.359.
      • 15.0.1300.359
        • SQL Server 2019
  2. Edition
    • Current edition is: [Enterprise Evaluation Edition].
  3. DmpClient
    • Failed to get DmpClient. [HRESULT=0x8007007F]
  4. Service Account
    • Windows service “Microsoft SQL Server Distributed Replay Client” has started under service account “NT Service\SQL Server Distributed Replay Client”.
  5. Controller
    • Controller name is “LAB”.
  6. Registered
    • Registered with controller “LAB”.

Summary

Please grant your Distributed Replay Controller and Client Accounts the following component services privileges :-

  1. Component :- DReplayController
    • Launch and Activation” Permission
      • Local Launch
      • Remote Launch
      • Local Activation
      • Remote Activation
    • Access Permission
      • Local Access
      • Remote Access

 

 

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s