Quick and Easy Data Access with Excel Services

SharePoint Link Love 07-Feb-09

Mirrored Blogs — Sun, 08 Feb 2009 02:48:59 GMT

Now available: 0.2.4.0 alpha for Orcas RTM - LINQ to SharePoint SPDiag Tool Released - Bob Fox's

re: Quick and Easy Data Access with Excel Services

ssas-info — Sat, 14 Feb 2009 06:10:13 GMT

Pingback.

Link to this article was posted on our website in the [SSAS Articles]/[Excel] section:

http://www.ssas-info.com/analysis-services-articles/53-excel/1388-quick-and-easy-data-access-with-excel-services

re: Quick and Easy Data Access with Excel Services

yipiha — Wed, 25 Feb 2009 13:20:07 GMT

Hi John,

Thanks for this!

For info, I could not connect at first in a situation where the SSAS server and the SP servers were on different machines. The SSAS's local account used from plain Excel on the SP's machine allowed me to see the data but when used as per your solution it did not work.

The problem was sorted by creating a similar local account (same name, same password) on the SP server (hence the unattanded service account I used was not "domain\username", as in your screenshot, but simply "username").

I think it can be helpful to precise it in your text for people as bad as me on Security.

Thanks again :)

Yipi.

re: Quick and Easy Data Access with Excel Services

I have been looking for this information for days. Thanks very much.