I have schedule lite optimization but however it always fail. However the lite optimization will successfully completed when run manually. The log stated for the fail schedule lite opt was "Error connecting to OLAP: Errors in the OLE DB provider. The data source or location is not valid. Provide a valid server to which to connect." Anyone can give some hint on this as what to check.