Reporting Services Error

I am having trouble determining the cause of this error:
Reporting Services Error
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'Footprints'. (rsErrorOpeningConnection) Get Online Help
Cannot open database requested in login 'Footprints'. Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I have checked and each of the virtual server folders in IIS are using NT Authentication and the report was created with a connection that used NTAuth. Not sure where the anonymous is coming from.
Any suggestions?
Is this a scheduled report or one that is created on demand?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:F3A800A5-3906-43E3-9565-67403F71956B@.microsoft.com...
> I am having trouble determining the cause of this error:
> Reporting Services Error
> ----
--
> An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
> Cannot create a connection to data source 'Footprints'.
(rsErrorOpeningConnection) Get Online Help
> Cannot open database requested in login 'Footprints'. Login fails. Login
failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> ----
--
> I have checked and each of the virtual server folders in IIS are using NT
Authentication and the report was created with a connection that used
NTAuth. Not sure where the anonymous is coming from.
> Any suggestions?
|||Dennis,
if your database is on another server to RS, then this may be a Kerberos
issue. You'll need to ensure it is enabled for this to work.
HTH,
Paul Ibison
|||(Assuming you're using impersonation that is...)
Regards,
Paul