Login failed for user '(null)'

I have several reports using the same database with the same credentials
(using a specific Username and Password). All display fine, except for one
that gives me the following Reporting Services Error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'BCSpotBonus'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
I've configured the data in the same way as the other reports and I've tried
using the "Shared database option" and not using the "Shared database
option." Nothing works. How can this be happening?That shouldnt be happening , but even i had the same
problem.
In the Report Designer try to delete the datasource and
then add it again and re deploy the report. Then try to
view the report.
Hope this helps!
>--Original Message--
>I have several reports using the same database with the
same credentials
>(using a specific Username and Password). All display
fine, except for one
>that gives me the following Reporting Services Error:
>An error has occurred during report processing.
(rsProcessingAborted) Get
>Online Help
>Cannot create a connection to data source 'BCSpotBonus'.
>(rsErrorOpeningConnection) Get Online Help
>Login failed for user '(null)'. Reason: Not associated
with a trusted SQL
>Server connection.
>I've configured the data in the same way as the other
reports and I've tried
>using the "Shared database option" and not using
the "Shared database
>option." Nothing works. How can this be happening?
>.
>