Finance | Project Operations, Human Resources, ...

SSRS Reports that are run within GP

(0) Share

Report

Posted on by sdcraig

366

I have a customer where several users are getting the attached error - I have verified that the Datasources are set to "As the user running the report" and I am going to change it to a "Use the following Credentials", but I was wondering if anyone would know why the Anonymous Logon would just stop working

6283.SSRS.jpg

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Mick Egan 3,561 on at

Like (0)

Report

RE: SSRS Reports that are run within GP

What you might find is that some of the AD Users are in a Security Group i.e. DOMAIN\GPUsers, in SQL and others are not in the AD Security Group.

The AD Group may acess to the Objects in the Databases.

Mick
Suggested answer

Derek Albaugh on at

Like (0)

Report

RE: SSRS Reports that are run within GP

If you look in SQL, under Security > Logins, do you have NT AUTHORITY\ANONYMOUS LOGON listed?

I don't on mine, by default, I do have other service accounts, so I'm wondering if it's failing the login on SQL, when trying to connect to the GP databases to pull the data into the SSRS reports?

Thanks