Addition of new delivery controller in existing site failed with Error ID XDDS:773674D1

Addition of new delivery controller in existing site failed with Error ID XDDS:773674D1

book

Article ID: CTX463910

calendar_today

Updated On:

Description

  • When we try to add new controllers to existing site an error occurs when joining our the new Delivery Controllers. Failed to update database. Error details: Error Id: XDDS:1FA8BEDF
  • There was another Error Id seen later on - XDDS:A3A3B056
  • Issue was present despite following the CTX Article - CTX225347
  • SQL Database was hosted on an Always On HA cluster

Resolution

Allowed network communication from all delivery controllers to all SQL servers.
Individual SQL nodes as well to Always On Listener IP.

Problem Cause

  • We initially followed Article - CTX225347 and cleaned up the failed addition of Delivery controllers.
  • After that, we tried adding the controller again, it popped up a new error ID - XDDS:A3A3B056
  • Ran "Test-NetConnection -Computername "SQL Node IP" -Port 1433 and this returned false.
  • Requested to have TCP Port 1433 opened up from all controllers to all SQL nodes individual IP as well as Always On Listener IP