Report Builder filter not working RRS feed

  • Question

  • WE're running a SQL 2005 instance of SQL Server Reporting Services.

    When I am using report builder, I attempt to add a filter for a specific field. WIthin the filter screen, I get a yellow triangle with an error message saying it can't connect to data source or it's invalid.

    I run SQL profiler, and see no SQL being executed against my source database when trying to add/build the filter.

    When I execute the report, it works fine (and I see the SQL in Profiler).

    In the logs, I receive this error immediately after the line accessing the model (though not sure of the timing with this, whether it's accessing the model OR hitting the filter):
    Throwing Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed., ;

    I do have a custom forms authentication piece setup, but that's working fine.

    Any ideas?

    Wednesday, September 2, 2009 8:38 PM