Error connecting to Data Source in SSRS

reporting-services connection-string datasource ssrs-2008-r2 credentials
Aruna Raghunam picture Aruna Raghunam · Jan 13, 2017 · Viewed 8.3k times · Source

I am trying to connect to Datasource but getting this error:

An error occurred during local report processing. 
An error has occurred during report processing. 
Cannot create a connection to data source 'PO'.
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.

Any idea how to resolve this?

Thanks Aruna

Answer

NewGuy picture NewGuy · Jan 13, 2017

Looks like it forgot your password, If it is an embedded data source > Right click on the Data source then go to properties > credentials.

If it is a shared data source go to the shared data sources, right click on the shared data source and hit Open, once in there click on credentials and enter the credentials again.

Related questions

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More
How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
SQL variable to hold list of integers

I'm trying to debug someone else's SQL reports and have placed the underlying reports query into a query windows of SQL 2012. One of the parameters the report asks for is a list of integers. This is achieved on the report …

Read More