Banks, credit unions, insurance companies,
Netwrix Auditor complains about Anonymous Logon when looking at SSRS-based Reports.
|Symptoms||If you have SSRS Server located on one SQL Server instance while the database containing data is stored on a separate SQL Server instance , you may get the following error message:
"Cannot create a connection to data source 'DS'. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
Assuming this is the only issue, if you try to generate the report from the SQL Reporting site it will be generated without any errors.
|Cause||It happens as a result of double-hop authentication.
The double-hop issue is well described in the following article - http://blogs.technet.com/b/askds/archive/2008/06/13/understanding-kerberos-double-hop.aspx
|Resolution||Select one of the proposed solutions to resolve this issue and perfrom the following steps:
NOTE: Perform these steps for each target system (registry edit first followed by updating Report Manager datasource). Report Manager datasource settings will be reset when you run a report from the Netwrix Auditor if the registry key is not present.
NOTE: This solution increases your server's vulnerability to attack by malicious users or software.