Export (0) Print
Expand All

Manage settings for single sign-on

SharePoint 2007

Updated: March 26, 2009

Applies To: Office SharePoint Server 2007

Updated: 2009-03-26

In this article:

About single sign-on settings

Excel Services in Microsoft Office SharePoint Server 2007 supports three data authentication methods: Integrated Windows authentication, single sign-on (SSO) authentication, and None.

Imagine a data connection in a workbook opened in an Excel Calculation Services application server that uses stored credentials for authentication against an external data source. In this scenario, Excel Calculation Services has to retrieve valid credentials from an SSO authentication database, and then use the credentials to authenticate against a data source before the data connection can be established.

To enable SSO functionality for Microsoft Office SharePoint Server 2007, you need to start the Microsoft Single Sign-On service, and then manage SSO settings in the SharePoint Central Administration Web application.

Manage single sign-on settings

Use the following procedure to manage SSO settings.

Manage SSO settings

  1. From Administrative Tools, open the SharePoint Central Administration Web application.

  2. On the Central Administration home page, click Operations.

  3. In the Security Configuration section, click Manage settings for single sign-on.

  4. On the Manage Settings for Single Sign-On page, click Manage server settings.

  5. In the Account Name box for the SSO Administrator account, type the same domain and user name that you used to configure the Single Sign-On service. If the user name you used to configure the Single Sign-On service is a member of a Windows security group, you can type the name of the Windows security group instead of a user name.

  6. In the Enterprise Application Definition Administrator Account box, type the same domain and user name that you used to configure the Single Sign-On service.

Download this book

This topic is included in the following downloadable books for easier reading and printing:

See the full list of available books at Downloadable books for Office SharePoint Server 2007.

See Also

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft