Start the Single Sign-On service

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 authentication

  • Start the Single Sign-On service

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


Manage settings for single sign-on