We were told that Excel Services has support for displaying data from external locations, such as SQL server, and that's great! Until you try it out and fail.. Try creating a simple excel document with a Table that displays data from a SQL server
Read More...
Read the complete post at http://blogs.microsoft.co.il/blogs/itaysk/archive/2007/11/08/using-external-data-in-excel-services.aspx