Hello Good Afternoon,

We are getting the below error while trying to access reports from the remote server (in same domain) from web console "500 Internal Server Error - There is a problem with the resource you are looking for, and it cannot be displayed."

In our environment we have 3 servers one is SQL server and two are SCOM servers. Please advise how to fix this issue. Do we have to do any thing from SQL End?

Hi,

You need to have more detail from Event Log or IIS log. With this very generic error and without context, it is difficult to justify what caused the problem.

Hi,

Hope it helps:

https://michelkamp.wordpress.com/2013/05/22/how-to-fix-the-500-error-using-favorite-reports-in-the-scom-web-consol

I think sanjeevkumarn make same thread as below, which is solved

https://social.technet.microsoft.com/Forums/en-US/63cce275-30a7-4c33-80b2-0c2372400ed5/scom-500-internal-server-error-there-is-a-problem-with-the-resource-you-are-looking-for-and-it?forum=operationsmanagerreporting

Roger

Did you restart the IIS Services and check once ?

Reboot all the server's once during off peak hours and check

Try adding your SCOM accounts to those two groups:

Logon Locally (Could be Administrators, Users or Backup groups)

Performance Log Users

Performance Monitor users

Regards, 

Eden Oliveira