Click here to Skip to main content
15,921,212 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

I have a set of SSRS reports that use an excel sheet as a datasource.
Now when I preview the reports or run them in the Visual Studio IDE on my local machine i.e
the development machine, the reports run fine & display all correct results.

However, when we deploy the reports to the Production machine which is on a separate server,
the following error message is displayed :
"The current action cannot be completed. The user data source credentials do not meet the requirements to run this report. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)"

I've copy pasted the connection string used for connecting to the excel file as reference :

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyFolder\CurrentRRFile.xlsx;Extended Properties="Excel 12.0;HDR=Yes;";

The excel file has also been uploaded to the machine housing the reporting server (i.e to C:\MyFolder location)

Any help would be hugely appreciated.

Maciej Los 15-Dec-13 16:23pm    
There is no local drive ("C:\"), but there is a shared folder... Refer to the path on SSRS server where Excel file is placed.
Have a look here: Embedded and Shared Data Connections or Data Sources (Report Builder and SSRS)[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900