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 [...]

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. [...]