XL Connect error

I have a new user who I setup with XL Connect access. However, when he tries to use XL Connect, he gets this error message:

The permissions granted to user ‘[DOMAIN][USER]’ are insufficient for performing this operation. —> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user ‘[DOMAIN][USER]’ are insufficient for performing this operation.

(Removed the Domain name & User name)

I gave him the same access as any other user, but he keeps getting this error.

Anyone else run across this?

This is an SSRS POrtal error make sure his permissions in your SSRS portal are correct.

We have two SQL servers:

  1. Database
  2. For SSRS

He’s created as a user in both with datareader access to the Epicor Live database.

Where do I go to configure the SSRS portal?

The SSRS Report URL
Usually
http:///Reports

Is whatever the SSRS Report Server that XL Connect (connects) to