Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' RRS feed

  • Question

  • Hi,

    I have a problem in SSRS Web Part.

    First, let me explain the architecture:

    I've a single server with sharepoint server and sql server reporting server installed on it. My Sql Server for Project Server is on a seperate server.

    On the SQL Server Reporting Server, I have a "SharePoint Integrated Reporting Database".

    The problem:

    When I create a report with Report Builder 3.0 (with embedded connection in the report and credentials set to "Use Current Windows user"), save it to my local comnputer and run it, everything is fine. But when I deploy it on the document library of my PWA site's BI center (http://servername/pwa/ProjectBICenter/Sample%20Reports/MyReports) and add the report in a web part, I get an error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

    How can I solve this problem? Any idea?

    Friday, March 22, 2013 2:21 PM

All replies

  • Nuri,

    How SSRS authentication is configured from SharePoint Central Admin, trusted account or windows integrated?

    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you.This can be beneficial to other community members reading the thread.

    Friday, March 22, 2013 4:16 PM
  • Sorry for my late reply.

    The "Authentication Mode" is "Windows Authentication".

    Sunday, March 24, 2013 11:22 AM