I have a sharepoint 2013, it is configured for integration mode. From SQL2012, I publish a simple SSRS report to the SP2013. The publish succeeded, but when view the report, it shows this error:
An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
On the sql server log, it has this error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided. [CLIENT: 192.168.1.91]
The SSRS uses windows authentication. So, I changed it to SQL authentication, it has the same error. Then on SP2013, I changed it to use stored credential, same error.
Weird thing is: it worked before, but I do not know what happened to the server since then.
Anyone have any idea/suggestions?