SharePoint Use Cases

I had a lot of trouble with Excel Services. I wanted my Excel file to refresh data from SQL database. However, the following error appeared constantly:
Unable to retrieve external data for the following connections:
Connection_Name
The data sources may be unreachable, may not be responding, or may
have denied you access.
Verify that data refresh is enabled for the [...]

Last week I was busy setting up BDC, Search and Excel services for my company intranet site. I will be posting a series of posts on these topics but today I will put a few notes on SSO. You will definitely need SSO for BDC and BDC Search; for Excel services there are some workarounds.
You [...]