When running reports in Sandbox, username and password are asked for.
This typically occurs when you ask for a Sandbox refresh from Production and exclude reports. In this situation, the reporting service is usually not restarted.
Log a Support ticket for reporting to be enabled.
To prevent this situation, please ask for reporting to be restarted when you refresh Sandbox from Production and exclude reports.