I have a query that uses a linked server from a SQL Server 2012 instance to a SQL Server 2008 instance. When I run the query directly on the SQL Server 2012 box using SMS, it works fine. When I add the query to my BIDS 2008 client and try to use it within the Reporting Services report, I get this error.
"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
What am I missing? I've looked online, but have been unable to find a solution.