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 will learn everything you need to know about SSO configuration here: http://technet2.microsoft.com/Office/en-us/library/841080ca-3e3b-4dbc-a081-43c29c76b3551033.mspx?mfr=true
As usual there were a few problems whit configuration. My SSO account had problems accessing SSO SQL Server, I received all kinds of stupid errors. I solved problems by simply logging as SSO account on to SharePoint server using Remote Desktop. Everything worked fine after that, so if you encounter any permission problems just login to your SharePoint server as SSO account.
