Issue Installing Reporting Server
I have recently uninstalled SCOM Reporting Service from my SQL server in an attempt to fix a reporting issue.  The problem is that when I attempt to reinstall Reporting Services on the SQL server, I get to the screen where I enter the Data Reader account but then get an error message that says "Data Reader account provided is not same as that in the management group".
 Any idea what may cause this?  I've rebuilt both the Data Warehouse and Report Deployment run as accounts, still didn't fix the issue.  I've also run ResetSRS on SQL, a no-go.
January 28th, 2015 7:55pm

Did you run the SRSconfig tool before running the opsmgr reporting install?

Option 1: Run srsreset tool for sql 2008 R2. then try to run the install again. start omsetup.exe from an elevated command prompt.

Option 2 : uninstall ssrs, and iis. reboot. install iis, install srs, run srs config tool to make sure web sites, db to use, and resoruce pools are setup. verify http://servername/reports and http://servername/reportserver function as expected. The try and run opsmgr reporting.

People have resolved their errors by following this -

(1)

After you complete the upgrade process, you must distribute the Run As account to ensure that all members of the resource pool (All Management Servers Pools) have access to the permissions in the Run As account.

  1. Administration workspace.
  2. Run As Configuration, select Profiles.
  3. Data   Warehouse Account.
  4. Run As Profile Wizard, click Next twice, or click Run   As Accounts in the left pane.
  5. Data Warehouse Action Account, and click Remove.  Then click Add to add a new Run As account.
  6. Add a Run As Account dialog box, under Run   As account, select Data Warehouse Action Account and then select A   selected class, group, or object.  
  7. Select, and then click Class.
  8. Class Search dialog box, under Filter   by (optional) type Operations Manager APM Data Transfer Service, and then click Search.
  9. OK, then click OK in the Add a Run As   Account dialog box to associate that item   with the Run As account.
  10. Data   Warehouse Action Account. This time   search for and add the following classes:
    •        Data   Warehouse Synchronization Server
    •        Data Set
    •        Collection   Server
  11. Save to create the Run As Profile.
  12. Close.
  13. Profiles list, double-click Data   Warehouse Report Deployment Account.
  14. Run As Profile Wizard, click Next twice, or click Run   As Accounts in the left pane.
  15. Data Warehouse Report Deployment   Account, and click Remove.  Then   click Add to add a new Run As Account.
  16. Add a Run As Account dialog box, under Run   As account, select Data Warehouse Report Deployment Account and select A   selected class, group, or object.  
  17. Select, and then click Class.
  18. Class Search dialog box, type Data   Warehouse Synchronization Server,   then click Search.
  19. OK, then click OK in the Add a Run As   Account dialog box to associate that item   with the Run As account.
  20. Data   Warehouse Report Deployment Account.   This time search for and add Collection   Server to associate that item with the   Run As account.
  21. Save to create the Run As Profile.
  22. Close.

(2)

                   

By adding the account in question to the Operations manager report security administrators role.

This is done in the operations console.

1. goto administration

2. security

3. user roles

4. profile: report security administrator.

5. Operations Manager Report Security Administrators

6. add your user.

You also might be able to get by by adding the account to just the report operators but i didn't test this

(3) Remove and re-add the profile targeting the report part.

Hope this helps..

Free Windows Admin Tool Kit Click here and download it now
January 29th, 2015 8:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics