sql server reporting services: When I run an RS report on server1 that connects to a sql database on server2
I get the error:

"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. "

Jimbo,

Check the IIS settings, under the "Directory Security" tab on the website
properties.

A few possibilities. Are you calling the report on server1 from another
server. If so, then you might be seeing the double hop issue.

My guess is that your web site on Server1 is running anonymous AND you are
using windows security credentials to access the sql database source. In
report manager open up the data source. If you have Windows Integrated
Security checked that means RS will use the windows credentials of the
person running the report to access the data. If the website is in anonymous
mode then RS does not know who that user is. Also, all users will be quests,
nobody will have admin rights (including yourself) if the website is in
anonymous mode.

Two points, you cannot run the website in anonymous mode (unless you
perpetually take it out of anonymous mode anytime you need admin
priveleges). Second, my suggestion is to pick one of the other two
credentials options, have all users for a report use the same account to
access the data. I run SQL in mixed mode and have a SQL login just for
reporting that gives only readonly data access. This is better for
performance too since connection pooling will now work.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]