Start the Single Sign-On service

SharePoint 2007

Updated: March 26, 2009

Applies To: Office SharePoint Server 2007

Updated: 2009-03-26

In this article:

About single sign-on authentication

In Microsoft Office SharePoint Server 2007, single sign-on (SSO) authentication enables users to access multiple system resources without having to provide authentication credentials more than once. Office SharePoint Server 2007 implements SSO authentication by including a Windows service and a secure credentials database.

To authenticate a data connection in a workbook against an external data source, you can configure Excel Calculation Services to retrieve authentication credentials from an SSO store. To enable SSO functionality for 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.

Start the Single Sign-On service

Use the following procedure to start the Single Sign-On service.

Start the Single Sign-On service

  1. From Administrative Tools, click Services.

  2. Double-click Microsoft Single Sign-On Service.

  3. On the Log On tab of the Single Sign-On Service Properties page, click This account, and then type the domain, user name, and password that you have used to install and manage your server.

  4. Click Apply.

  5. On the General tab of the Single Sign-On Service Properties page, change the startup type to Automatic, click Start, and then click OK.


    Start the Single Sign-On service on all front-end Web servers and all application servers in your farm that run Excel Calculation Services.

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