Error message when you try to configure the SSO service on a computer that is running SharePoint Server 2007: "Failed to connect to the database server"

You remove and then install Microsoft Office SharePoint Server 2007. When you try to configure the single sign-on (SSO) service on the computer that is running SharePoint Server 2007, you receive the following error message:

This problem occurs if SharePoint Server 2007 tries to create an SSO database by using the same database name that was used by an earlier installation of SharePoint Server 2007.

To work around this problem, use one of the following methods.

Method 1: Delete the Sso.mdf and Sso_log.ldf database files

1. Make a backup of the Sso.mdf and Sso_log.ldf database files.
2. Delete the original Sso.mdf and Sso_log.ldf database files.
3. Configure the SSO service on the server that is running SharePoint Server 2007.

Note The Sso.mdf and Sso_log.ldf database files may be on the computer that is running Microsoft SQL Server or in the following location:

Method 2: Use a different SSO database name

Use a different SSO database name when you configure the SSO service.