SCCM 1702 Data Warehouse Synchronization Service encounters error (Server ‘serverXXX’ is not configured for DATA ACCESS.). Please refer to the Microsoft.ConfigMgrDataWarehouse.log for details.

Resolution-

Enable SQL Data Access.

exec sp_serveroption @server = YourDBServer

,@optname = ‘DATA ACCESS’

,@optvalue = ‘TRUE’

If there are security concerns or requirements disable this after the Data Warhouse has been deployed, then re-enable for Data Warehouse updates.