Menu
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
937
If you can't connect to a report server, you either don't have permission to access it, or the server isn't registered. To register the server, select View menu > Registered Servers. Select the Reporting Services icon. Right-click Reporting Services, > New > Server Registration.
This log is on by default and can be found in: C:\Program Files\Microsoft SQL Server\MSRSXX. SQL2012\Reporting Services\LogFiles or some variation depending on your SQL Server installation.
11-26-2020 07:17 AM Please help I am stuck, getting the error below on ssrs datasource : The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.
The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly. An attempt has been made to use a data extension 'OLEDB' that is either not registered for this report server or is not supported in this edition of Reporting Services.
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.
This is a common error in SQL Server Reporting Services reports which is caused by incorrect security setup. Let’s look at SQL Server Reporting Services reports and how we can resolve this kind of error: SQL Server Reporting Services (SSRS) reports are one of the best ways to get and review data in Microsoft Dynamics GP.
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.
135
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
