SQL Server Developer Center > SQL Server Forums > SQL Server Reporting Services > Datasource using unattended report processing account won't let me build datasets using Report Builder 2.0
Ask a questionAsk a question
 

QuestionDatasource using unattended report processing account won't let me build datasets using Report Builder 2.0

  • Wednesday, November 04, 2009 9:08 PMhics0 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I have a datasource defined on a SP integrated instance of SQL RS 2008 that is configured to use the unattended report processing account so that I can create snapshots.  When I create a report using Report Builder 2.0 specifying that datasource and try to create a dataset I am prompted for data source credentials.  When I attempt to specify credentials I receive the error:

    "You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server."  

    I have the unattended account configured, so I don't know what I'm doing wrong.  Is this combination supposed to work?  If so, what can I check to verify that I'm not doing something wrong?

    Thanks,

    Steve

All Replies