What needs to be changed when the host name of the direct audit server is changed to ensure it's able to connect to SQL server successfully?
If the host name changed on machine that has the Direct Audit collector and the Direct Audit audit Database components, for the Collector nothing needs to be done because it will update itself to the new host name.
For the Direct Audit audit Database, however, two steps are needed in order for the new host name to take effect:
1) launch SQL Server Management Studio, connect to the Instance where DirectAudit exits, Expand the <Installation>ManagementDatabase, update table AuditStoreDatabase, column 'Server' to have the new FQDN of new host name.
2) launch DirectManage Audit Manager console, right click the <Installation> and select 'Properties'. Go to 'Publication' tab, select each location and click 'Synchronize'
Then monitor the collector to confirm if it picked up the new Direct Audit audit database from the Collector Control Panel available from the Start menu on any Windows computer on which a collector is installed.