On standalone configuration where ECS (Excel Calculation Services) and Microsoft SQL server reside on same machine, external resources such as tables and cubes should be accessible via Office Data connections (ODC) in Trusted Subsystem mode (Default settings)
