[SCOM 2007 R2] Loading reporting hierarchy failed

Posted: December 11, 2012 in SCOM 2007 R2, System Center, Troubleshooting

Loading reporting hierarchy failed

Symptoms

clip_image001

Root cause:

The report server cannot open a connection the the report server database

Workarround:

Reset password SQL Reporting Server uses to connect to the reports server database using script below

RSConfig.exe -c -s JKT-SCOM -d ReportServer -a Windows -u domain\admin.sqlscom -p password2010!!!

clip_image002

Result:

clip_image003

 

Source:

http://social.technet.microsoft.com/Forums/en-US/operationsmanagergeneral/thread/8a4e09d5-ea27-4491-b258-b0758ca77111

http://blogs.technet.com/b/randymonteleone/archive/2010/03/12/changing-password-on-scom-data-warehouse-run-as-accounts.aspx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s