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.