Manage settings for single sign-on

Applies To: Office SharePoint Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.


Topic Last Modified: 2016-11-14

In this article:

  • About single sign-on settings

  • Manage single sign-on settings

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


Start the Single Sign-On service