Home Forums SQL Server 2012 SQL 2012 - General SSRS Data Source using Windows integrated security gives Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. RE: SSRS Data Source using Windows integrated security gives Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

  • If your shop allows it just create a new windows user account and put it in Credentials stored securely in the report server and check use as windows credenitals when connecting to data source and make sure it has the correct permissions for what the report is doing.