When I publsih the crystal report created from Excel as source using DAO connection,while refreshing the report,it prompts for database login.Even though the option is set to use the same database login at CMC level,it did not work.

 

This happens frequently not only with excel source but with other database.

 

Kindly suggest a solution,

Thanks in advance