Microsoft KB Archive/822265

= You receive a &quot;Cannot generate SSPI context&quot; error message and the configuration database is not created when you run SharePoint Portal Server 2003 Setup =

Article ID: 822265

Article Last Modified on 5/31/2007

-

APPLIES TO


 * Microsoft Office SharePoint Portal Server 2003

-





SYMPTOMS
When you run SharePoint Portal Server Setup to install SharePoint Portal Server 2003 to a server in a server farm, you may find that the configuration database is not created, and you receive the following error message:

Error

Cannot generate SSPI context.



CAUSE
This issue may occur in situations when there are entries that exist in Active Directory from a previous installation of SharePoint Portal Server, and these entries prevent Microsoft SQL Server from registering itself correctly in Active Directory.



RESOLUTION
To resolve this issue, follow these steps:  On the server in the server farm, that is running Microsoft SQL Server, click Start, and then click Run. In the Open box, type cmd, and then click OK. Type the following line at the command prompt, where  is the name of the server that is running Microsoft SQL Server 2000, and then press ENTER:

setspn –l

A list of service principal names that are currently registered for the server are displayed. From the list of currently registered service principal names that is displayed earlier in step 3, make a note of each service principal name that starts with the following text:

MSSQLSvc

 Delete each service principal name entry that starts with MSSQLSvc. To do so, type the following line at the command prompt, where  is the service principal name entry that starts with MSSQLSvc and   is the name of the server that is running Microsoft SQL Server, and then press ENTER:

setspn –d

Repeat this step for each service principal name entry that starts with MSSQLSvc. Restart the server.</li> Create the configuration database.</li></ol>

Note If the symptoms that are described earlier in the &quot;Symptoms&quot; section of this article persist after you perform this procedure on the server that is running SQL Server, perform this procedure on each server in the server farm.

<div class="moreinformation_section">

MORE INFORMATION
In Microsoft Windows Server 2003, the Setspn.exe command-line tool is included with the Windows Support Tools. You can install the Windows Support Tools from the Support\Tools folder of the Microsoft Windows Server 2003 CD-ROM.

In Windows 2000, the Setspn.exe command-line tool is included with the Windows 2000 Resource Kit. For more information about the Windows 2000 Resource Kit, visit the following Microsoft Web site:

http://www.microsoft.com/windows2000/techinfo/reskit/default.mspx

For more information about how to deploy, how to configure, and how to administer SharePoint Portal Server, see the Microsoft Office SharePoint Portal Server 2003 Administration Guide. The Microsoft Office SharePoint Portal Server 2003 Administration Guide (Administrator's Help.chm) is located in the Docs folder in the root folder of the Microsoft Office SharePoint Portal Server 2003 CD-ROM.

For more information about SharePoint Portal Server, visit the following Microsoft Web site:

http://office.microsoft.com/en-us/sharepointserver/FX101494611033.aspx

Keywords: kbdatabase kbsetup kberrmsg kbbug KB822265

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.