Showing posts with label SSRS report. Show all posts
Showing posts with label SSRS report. Show all posts

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.








Report labels does not show up in X++ report

The report labels do not display, or the report shows label IDs, like Labels!@SYS2123 instead of the label values. 
There are two reason for this type of issue:
   1.  Either you have recently moved your AX service account from AX domain admin group
   2. Or your have changed your SSRS service account password

Solution:
  1. From the Start menu, point to All Programs, click the SQL Server folder, click the Configuration Tools folder, and then click Reporting Services Configuration Manager.  
  2. In Reporting Services Configuration Manager click Connect and then click Service Account.
  3. Set the password and then click Apply. The account and password should be the same as the Microsoft Dynamics AX proxy account. 
  4. System will ask you to backup your encrytion key, and then will some settings on the backhand.
  5. Now Click the ServerName/MSSQLSERVER on the left top of the reporting server and then click Stop. Then click Start to restart the server. Always check with the SQL administrator and make sure no other users are connected to the server before you restart the server.
Now try opening your report again, your issue will be resolved.