DReplayClient – DCOM was unable to communicate with the computer ( Error – 10028 )

Background

It is never a good sign to wrought so much errors post a clean install.

I performed a clean install of SQL Server 2014 and had to go back to apply SSL Certs to Reporting Services.

Noticed errors in Event Viewer.

Errors

  1. Event ID :- 10028
    • Log Name :- System
    • Source :- DistributedCom
    • General :- DCOM was unable to communicate with the computer MSSQLServer using any of the configured protocols; requested by PID ### (E:\Program Files (x86)\Microsoft SQL Server\120\Tools\DReplayClient\DReplayClient.exe).
    • GUID :- Guid=”{1B562E86-B7AA-4131-BADC-B6F3A001407E}”

 

 

Remediation

Component Services

Launched Component Services.

DReplayController

Accessed Console Root \ Component Services \ Computers \ <My Computer> \ DCOM Config \ DReplayController node.

Right click the selected node and from the drop-down menu choose “DReplay Controller“.

The “DReplayController Properties” window appears.  In the window choose the “Security” tab.

Within the Security Tab, there are three group boxes.  The three are “Launch and Activation permissions“, “Access Permissions“, and “Configuration permissions“.

In the  “Launch and Activation permissions” group box, please choose the “Edit” button.

DReplayController – Post Install

Here is what things look post install.

We have two users defined, myself and my fellow DBA.

DReplayController – Post Customization

 

Pasted above is what things look once we made the changes listed below:

  1. Granted :
    • Local Activation
    • Remote Activation
  2. Group or Username
    • SQL Server Distributed Replay Controller
    • SQL Server Distributed Replay Client

 

 

Distributed Replay Client

Controller Name

The error is just what it says it is.

Here is the error message:-

DCOM was unable to communicate with the computer MSSQLServer using any of the configured protocols; requested by PID ### (E:\Program Files (x86)\Microsoft SQL Server\120\Tools\DReplayClient\DReplayClient.exe).

As a review, during SQL Server install I included Distributed Replay Client.

Sample Install Screen

The entry that is pertinent here is Controller Name.

Service – “SQL Server Distributed Replay Client”

Path

Accessed Control Panel, specifically the Services applet and dug into the “SQL Server Distributed Replay Client” service.

Recorded the path to the executable.

 

DReplayClient.config
DReplayClient.config – Post Install

Accessed the folder recorded and using an editor loaded DReplayClient.config

DReplayClient.config – Revised

Replaced MSSQLServer with localhost as the Replay Controller is on same host.

Restarted “SQL Server Distributed Replay Client“.

References

  1. Installing and Configuring SQL Server 2012 Distributed Replay
    Link

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s