Hi,
Thank you very much for the update. Just to confirm with you, have we already tried the following solution from systemcenter wiki?
Ensure that there is connectivity from the Management Server to the SQL Server hosting the Data Warehouse. Communication could be blocked by a firewall for example. Ensure that the Data Warehouse Action Account is able to connect to the Data Warehouse database. If you are experiencing time-out issues, examine the utilization of the SQL server to determine if it's being overloaded. Important counters to look at are: CPU utilization, memory utilization and Disk I/O.
Hope the above information helps.
Alex Zhu
If the response is helpful, please click "Accept Answer" and upvote it.