SSRS driving me nuts!!!

[unclerico]

SQL 2000 SP3
Windows 2000 Server SP4

I am going absolutely nuts trying to get my reports to run correctly. First I'll give you the error returned by SSRS:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'ChemoDataSource'. (rsErrorOpeningConnection) Get Online Help
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

This only happens for users that are not part of the Domain Admins group. The really wierd thing is that executing these reports under my account in Domain Users has worked 3 or 4 times and then all of the sudden, nothing. I have IIS set to Windows Authentication, I have checked and double checked that my Domain User account is in the Browse role for the reports, the Data Source (shared) is configured as follows:

data source=apu;initial catalog=ChemoDatabase;trusted connection=yes

and it seems that no matter what option I choose under Connect Using I still get the above error message. Any ideas??

 

[ookete]

The permissions are also set up in SQL Server? Meaning, the same domain groups you are using for RS, do they each have the appropriate table/sproc/view permissions necessary to run their respective reports? I sometimes forget this.

 

[unclerico]

ookete, I ended up figuring it out, it looks like I just needed to add the NT AUTHORITY\ANONYMOUS LOGON to both the Reporting Services SQL Server and the SQL Server being reported against. The good thing in all of this is that I was able to learn a great deal about how SSRS works with IIS, Visual Studio, and SQL Server so I guess it was a blessing in disguise. Thanks again for your response.