Refresh problem with Excel services external data connection

Hello,

Snenario :Created a worksheet(report) in Excel 2007 and Excel Services using .ODC file.The .odc is created(SQL database) and registered in a trusted DCL in SharePoint.

The connection file is also exported to the SharePoint using Export Connection File in Connection Properties in the workbook.

"Enable Background Refresh","Refresh every n seconds" and "Refresh data when opening the file" checkboxes are checked in the usage tab while in the definition tab, "Always use connection file" is checked.

The Authentication is "Windows Authentication " for Excel services.Data is displayed in the Pivot table Report form.

The anonymous access for my application pool is enabled and set as "IUSR_WHP-SP01"(WHP_SP01 is the server name)(not set to my windows credentials)

In Allow External Data on the SharePoint, the trusted data connection libraries and embedded option is selected and the Refresh warning is disabled.

Issue :unable to refresh in the excel and the browser displays an error

Data Refresh Failed

Unable to retrieve external data for the following connections: whp-sp01 Test Employee The data sources may be unreachable, may not be responding, or may have denied you access. Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly set. What do i have to do to ensure refresh of data when the excel is opened directly or from the browser?

[3068 byte] By [PriyaG] at [2008-2-15]