RE: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'

SSC Guru

Points: 99126

August 1, 2017 at 1:50 am

#1953517

kazim.raza - Monday, July 31, 2017 7:28 PM
My data source is on another server, SQL Server 2014 instance, and this data source does not work with Integrated Windows Security. I don't get to the point of executing queries as I am getting errors at the time of setting up the data source.
The same database after porting into SQL Server 2016, works fine where SQL Server & SSRS are on the same box.

You say you aren't using Integrated Security, but NT_AUTHORITY/ANONYMOUS is an integrated security account. This sounds like you either have the datasource set use integrated security, and having a kerboros double hop issue (where your query connects to one server, and then queries a second in the T-SQL), or connecting anonymously.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk