Access was denied by the external data source. The following connections failed to refresh: "data connection name"

Hi !

I created a Excel report in Excel 2013 with a data-source as SQL stored procedure. I deployed this Excel report to Trusted Excel Library. I have done all configurations correctly in Excel Service Application in Central Admin 2013.

Whenever I open I receive below exception:


July 6th, 2013 8:22am

Can you look at the ULS logs and reproduce the error, put the files here?  I'm going to guess your stored ID in the secure store just doesn't have rights to your BCS external data source. 

You can also look at the Windows Events on the host server for permissions denied errors and or look in the SQL Logs in this is where your target data is coming from. 

Free Windows Admin Tool Kit Click here and download it now
July 6th, 2013 2:06pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics