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.