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:
|
1. |
On the server in the server farm, that is running Microsoft SQL Server, click Start, and then click Run. |
|
2. |
In the Open box, type cmd, and then click OK. |
|
3. |
Type the following line at the command prompt, where ServerName is the name of the server that is running Microsoft SQL Server 2000, and then press ENTER:
setspn –l ServerName
A list of service principal names that are currently registered for the server are displayed. |
|
4. |
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 |
|
5. |
Delete each service principal name entry that starts with MSSQLSvc. To do so, type the following line at the command prompt, where ServicePrincipalNameEntry is the service principal name entry that starts with MSSQLSvc and ServerName is the name of the server that is running Microsoft SQL Server, and then press ENTER:
setspn –d ServicePrincipalNameEntryServerName
Repeat this step for each service principal name entry that starts with MSSQLSvc. |
|
6. |
Restart the server. |
|
7. |
Create the configuration database. |
Note If the symptoms that are described earlier in the "Symptoms" 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.
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.
For immediate server support, call (877) 752-1122 or email support@exiis.net
About our Search Engine
Information on our site is produced from a variety of recourses including internal support professionals, Microsoft Product Support, Cisco Systems Support, and other third-party resources. The information is provided as a resource only and no warranty is given nor implied as to their accuracy. Our search engine is based on Microsoft Office SharePoint Server (MOSS) 2007 Search Technologies and filtered to produce the best possible results for our end users.
Overview of Exiis Corporation
Exiis Corporation is a client-centric, outsourced professional IT firm specializing in Microsoft Products and Technologies. Our extensive experience with network management and security, application support, and Cisco networking products make us an ideal partner when local resources and IT departments need additional support with their network services.
Microsoft and Cisco Support Technology
Our teams of professional consultants and support engineers have been providing local and remote network, server, and application support for nearly two decades, making us one of the oldest, experienced, and trusted outsourced IT service providers. Our unique “Pay-As-You-Go” model allows business organizations of all sizes to determine exactly how much they would like to spend on their outsourced IT budget, without the hassle of complicated monthly recurring fees or long-term contracts
Remote “Help Desk” Solutions
Exiis Corporation’s remote “Help Desk”, staffed by a team of Microsoft Certified Support Professionals can address these questions in a quick, efficient, time-saving manner that frees your IT team from having to research issues products that are new to them to or not normally maintained on a daily basis.
Access to Resources
Exiis Corporation offers access to the most prestigious collection of Microsoft Certified Professionals. Many organizations have some sort IT Support available to them, either internally or by a local computer provider. Exiis Corporation is able to augment the local IT talent with additional knowledge and experience in Microsoft Products and Technologies such as:
Microsoft Customer Relations Manager (CRM)
Microsoft Office SharePoint Server (MOSS)
Microsoft Exchange Server
Microsoft Great Plains Dynamics (GP)
Microsoft Internet Security and Acceleration Server (ISA)
Microsoft Live Communications Server (LCS)
Microsoft Operations Manager (MOM)
Microsoft Small Business Server (SBS)
Microsoft SQL Server
Microsoft Systems Management Server (SMS)
Microsoft Windows Server
Microsoft Office SharePoint Server (MOSS) 2007 Assistance and Custom Design Development
For larger organization or those that need to manage hundreds or even thousands of documents, who fall under regulatory compliance, and who are seeking a complete “one-stop-portal”, Exiis recommends utilizing the full version of Microsoft Office SharePoint Server (MOSS). MOSS allows for organizations to manage thousands of documents with complete security control, custom branding, advanced search, inter-operability with third-party applications, and a whole host of other features such as: Excel Services, Forms Server, and Business Catalog Services. Microsoft Office SharePoint Server (MOSS) is the de-facto standard for internal portal solutions.
For Additional Support, please see:
http://moss.exiis.net/sharepoint-server-support/Pages/default.aspx