Joining a DDC fails with an Error "Failed to update database" Error Id: XDDS:1FA8BEDF

Joining a DDC fails with an Error "Failed to update database" Error Id: XDDS:1FA8BEDF

book

Article ID: CTX477816

calendar_today

Updated On:

Description

Re-adding the same DDC after eviction from an existing site fails with an error "Failed to update database".  More details on the error would explain the below,

Error Id: XDDS:1FA8BEDF Exception: DesktopStudio_ErrorId : DatabaseError SqlServerOutput : (unknown datasource): (unknown database): Changed database context to '[SITE Name]'. (unknown datasource): (unknown database): Changed database context to 'tempdb'. (unknown datasource): (unknown database): Changed database context to 'tempdb'. (unknown datasource): (unknown database): Changed database context to '[SITE Name]''. (unknown datasource): (unknown database): Login [DDC System account] for controller [DDC System account] already exists (unknown datasource): (unknown database): Database user [DDC System account] already exists for controller [DDC System account] ErrorCategory: NotSpecified DesktopStudio_PowerShellHistory : UpdateDatabaseScript 

 

Environment

Citrix is not responsible for and does not endorse or accept any responsibility for the contents or your use of these third party Web sites. Citrix is providing these links to you only as a convenience, and the inclusion of any link does not imply endorsement by Citrix of the linked Web site. It is your responsibility to take precautions to ensure that whatever Web site you use is free of viruses or other harmful items.

Resolution

Validate if the DDC system accounts were deleted from Security > Logins as well as Database > Security > users sections. If a stale entry is found on either of the section, delete them and let the add DDC wizard create the login entries automatically.

For example, Repro\1912Infra$ is the system account for a DDC:

image.png

 Note: Always ensure to take a full DB backup before modifying the entries

Problem Cause

Stale entries of the DDC accounts on the Database

Issue/Introduction

Re-adding the same DDC after eviction from an existing site fails with an error "Failed to update database".  More details on the error would explain the below Error Id: XDDS:1FA8BEDF
Powered by Wolken Software