SteveGray 2/19/2012 2:48:10 PM

SSRS - Cannot create a connection to data source 'XXXX01'

  • Cannot create a connection to data source 'XXXX01'. (rsErrorOpeningConnection)
    • 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. (rsReportServerDataProviderError)

I'm getting this error after I change the datasource for a SQL SSRS report to use a specific set of credentials.

 

Version: Unknown or N/A
Section: SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3