Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

RDS Clustered Broker Service may meet database error on a Windows Server 2008 R2


View products that this article applies to.

Symptoms

Windows Server 2008 R2 RDS broker service, if setup as a clustered service, the service may meet database error intermittently.

In application event log, we can see:

After the error is reported, broker service hangs and never recover and the cluster active node is NOT failed over to the other node.

↑ Back to the top


Cause

This issue occurs because the broker service impersonate the cluster account when extending the ESE database log files and met access denied error.

↑ Back to the top


Workaround

Important This section contains steps that tell you how to modify the registry. However, serious problems might occur if you modifyhe registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base: 322756How to back up and restore the registry in Windows.

To resolve this issue,

1.  Click Start, click Run, type regedit in the Open box, and then click OK. 
2.  In Registry Editor, locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\TSSDIS\Parameters
3.  Take a note of the folder specified in the WorkingDirectory key. We will use the folder name later in the steps.

Note: Default it is %systemroot%\system32\tssesdir folder.

4. The fix is to add full control permission to the folder we find in step #1. for following accounts:
  • Broker Cluster Name Account
  • Network Services
5. After changing the folder permission, Quit Registry Editor, and then restart the broker service on the server.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 2678755
Revision : 1
Created on : 1/7/2017
Published on : 2/24/2012
Exists online : False
Views : 420