Ensure that the cube's data source uses an account with access to the source database. If it is impersonating the service account, ensure that the service account has access to the relational source.