Wednesday 23 May 2012

Reports showing username and password when opening SSRS report

When opening a report you see the username and password dialog














Now what is the possible reason for this issue. You might have changed your AX reporting service account to any other account in the reporting service extension recently, as shown below.

















Solution:

The solution for this might take some more time as expected. You need to open internet explorer and Run as Administrator. The type the reporting server link as shown below:

















Now you need to test one report e.g (TaxTable). Click on the Arrow sign and select 'Manage'

















Now browse to the 'Datasource' node of the reprot and check what is the data source applied, your datasource will have this option selected "Credential supplied by the user running the report" as shown below:
















Now by default this should be 'Windows integerated secutiy'. In order to achive this you need to delete all the reports first from the reporting server and then re-deploy all the reports from AX. Once you re-deploy the report from AX you will see all the report changed back to 'Windows integerated secutiy' option and then report will work fine. After re-deploy you window will look like this:
















Now try running the report again. Report will work fine.








No comments:

Post a Comment