Login failed for user '(null)' -- sql server reporting services

ladydi
9/16/2004 4:05:03 PM

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

Ravi
9/16/2004 9:50:59 PM

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!

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Login failed for user '(null)'