Error "There was an unexpected error while getting the report parameters" and allowing Non-Domain Admin users to run reports (4322659)

A user that is not a Domain Admin, but who does have Super User rights to Desktop Authority attempt to run reports and receives the following error:

Title: Unexpected error

Body: There was an unexpected error while getting the report parameters

Error: Login failed for user “Domain\User”

This error could occur if the firewall is enabled on the server where the SQL instance resides. Either disable the firewall or add a program or port exception to allow communications through the firewall.

A secondary error message may appear after clicking OK on the above message:

Unexpected error. There was a problem running this report. It is possible that the server did not have enough memory to run this report, the report timed out, or the server was unavailable. It is also possible that there was an error in the data or there was a problem with a hard-coded data comparison in the SQL statement cursor. Try running the report with a tighter parameter (i.e. fewer users, fewer workstations, smaller time spans, etc.) or check the report’s SQL statement.

Error message: object reference not set to an instance of an object.