in

SharePoint Blogs

The Best Place for SharePoint-related Blogs

Sharepoint Use Cases

This blog delivers real life use case and my opinions about Microsoft products.

SSO and Sharepoint

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.


 

Published Jul 11 2007, 12:39 AM by toni
Filed under: , , ,

Comments

 

Mark Teviotdale said:

Hi

Can you please explain your server setup ? is your SQL DB's on their own machine or on the same box as MOSS.  Have been having a few problems setting up this when the DB's are on a different box but in the same domain.

Thanks

Mark T

September 5, 2007 5:55 PM
 

toni said:

I have MOSS on one box. Sharepoint content databases and database which we are accessing via BDC are on other box in same domain.

SSO is setup to log every domain user with SQL authentication to read from BDC database.

September 6, 2007 3:23 PM
 

Mark Teviotdale said:

Hi Toni

Thanks for that, is it possible for you to post screen shots of you config of SSO in the sharepoint admin ? I think this is where i'm getting into trouble.

Thanks

Mark

September 10, 2007 8:33 PM
 

toni said:

Can you send me your email address and I will email you screens?

October 3, 2007 3:58 PM
 

Doug Kenrick said:

Toni, my address is dkenrick@cookcountytreasurer.com, could you send me the screenshots as well? We are having the same issues. Thanks,

Doug

October 10, 2007 11:14 AM

Leave a Comment

(required )  
(optional )
(required )  
Add

About toni

My name is Toni Frankola and a work as Microsoft Team Leader at Perpetuum Mobile, Croatia. This blog delivers real life use case and my opinions about Microsoft products. Summary: IT consultant specialized in Customer Relationship Management (CRM) software – Microsoft Dynamics CRM, and IW solutions - Microsoft Office SharePoint. Specialties: - IT Project Management, Software requirements analysis and software architectures, IT Consulting, IT Sales and Marketing, Product positioning - MCSD, MCAD, MCTS, MBSS, MCT http://www.linkedin.com/in/tonifrankola
Need SharePoint Training? Attend a SharePoint Bootcamp!
Posts (c) their respective authors. Everything else (c) 2007 SharePoint Experts