question

Ankur_1982 avatar image
Ankur_1982 asked

how to manage Kerberos Authentication Issues in a Reporting Services 2008 r2 Environment

I have few ssrs 2008 reports.I have created group of users and gave all required permissions to that group. Now when I am running those reports I am getting strange error. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' I don't know from where it came. I got suggestion that its a issue related to Kerberos authentication. Please some one knows how to solve this let me know. Or some one knows to solve this kerberos issue also tell me in steps if possible. Thanks Vik
sql-server-2008sql-server-2008-r2ssrsssrs-2008
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Martin Schoombee avatar image
Martin Schoombee answered
The first thing I would check is the settings of your datasource in Reporting Services. What authentication method are you using? Windows Auth? If that is setup correctly, i.e. either using Windows Auth or using a fixed account to access the database, I would recommend that you check all the settings in the SSRS Configuration Tool.
13 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Ankur_1982 avatar image Ankur_1982 commented ·
I have checked all these settings already. I deployed same reports in dev environment, they are working fine. But when i deployed in Test environment I am getting this error.
0 Likes 0 ·
Martin Schoombee avatar image Martin Schoombee commented ·
What are the properties of your data source(s) for these reports? Have you tried to login via remote desktop and execute the reports? Also, what is you SSRS service account on both servers?
0 Likes 0 ·
Ankur_1982 avatar image Ankur_1982 commented ·
all data sources are custom with windows authentication. Service account is network service in both servers.
0 Likes 0 ·
SirSQL avatar image SirSQL commented ·
Are your SSRS report using linked servers by any chance? What execution context are you using for the reports? Is it set to use the credentials of the user calling the report (impersonation); are you specifying a particular user (credentials stored securely in the report server); not requiring credentials; or having the user provide credentials when running the report?
0 Likes 0 ·
Ankur_1982 avatar image Ankur_1982 commented ·
1.right now i didnt set up any execution account. When I tried to put an account it gave me error unattended account. 1. Custom source with windows integrated security 2. I tried with credential stored still it was giving me error. 3. so I tried credential supplies by user This is not good. It is working but every time user has to give his\her admin account then he\she can view reports. Do you have any solution for that. (My report is running fine within the server only problem is with remote server)
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.