Reporting errors with login


I have deployed a report from a datasource on another computer running SQL 2005, the reporting server is on another server. When I run the report from the server itself it runs fine but when I run it using IE on my machine it gives me the following error: "An error has occurred during report processing.
Cannot create a connection to data source 'CampaignMasterData'.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. "

The report was created with Windows Integrated Security option.
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

climbingjaffaConnect With a Mentor Commented:
I'm not sure but this could be to do with allowing anoynomous logins over IIS.. This is a bit of a shot in the dark but i remember vaguely having some issue like this before. Hope this helps!
abhijitm00Author Commented:
Thanks for getting back climbingjaffa, is there a KB article I can read about this? Does anonymous authentication need to be disabled?
All Courses

From novice to tech pro — start learning today.