Event ID 5586, Cannot generate SSPI context

You get "Cannot connect to Configuration database" while accessing Central Administration or any SharePoint sites.

In Event Viewer we get the below error on the SharePoint server.

Event Type: ErrorEvent Source: Windows SharePoint Services 3Event Category:
Database Event ID: 5586
Date: 7/13/2009
Time: 12:36:31 AM
User: N/A
Computer: COMPUTERNAME
Description:Unknown SQL Exception 0 occured. Additional error information from SQL Server is included below. Cannot generate SSPI context.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

While trying to connect using connect.udl file, it gives the same error "Cannot generate SSPI Context"

On the SQL 2005 Server we get the below error.

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17836
Date: 6/25/2009
Time: 11:51:45 PM
User: N/A
Computer: COMPUTERNAME
Description:
Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT:IP of SP Server]

Quick Resolution:- Reboot the SQL Server 2005

Error Troubleshooting:-
How to troubleshoot the "Cannot generate SSPI context" error message
http://support.microsoft.com/kb/811889

This is related to some SPN configurations gone incorrect on the SQL server.

Resolution:-
Logon to the server using Domain Admin rights.
Download Setspn.exe from Microsoft site to set the SPN's for the SQL server.

At command prompt go to the location where setspn.exe was installed.
C:\Program files\support tools>setspn -L MyDomain\MyUserName
Registered ServicePrincipleNames for CN=MyUserName Service Account, OU=Service Accounts, DC=MyDomain,DC=com: mssqlsvc/MyServer1.MyDomain.com:MyPort mssqlsvc/MyServer2.MyDomain.com:MyPort mssqlsvc/MyServer3.MyDomain.com:MyPort

If you are getting the error (Cannot generate SSPI context), you will not find the SQL server name in the list displayed by the command.

To Register your SQL server type the following command.
setspn -A MSSQLSvc/MyServer.MyDomain.com:1433 MyAccount

Note:- MyServer will be the SQL server name to which you are not able to connect.

Again run the setspn -L MyDomain\MyUserName command, you should find your SQL servers FQDN registered.

Checklist before Planning System requirements for Deploying Sharepoint

Questionnaire

=> Access SharePoint sites from Internet (Y/N) If Yes,
No. of Current users who will be accessing SharePoint sites.
No. of Users projected to Access SharePoint sites by next 5 yrs.

=> No. of Current users who will be accessing SharePoint sites. (Intranet)
=> No. of Users projected to Access SharePoint sites by next 5 yrs. (Intranet)

=> Data to be uploaded on the SharePoint sites (in GB/TB)
=> Data to be uploaded on the SharePoint sites (in GB/TB) in next 5 years

=> No. Of Geographical Site locations

=> Requirement of Incoming Email Libraries (Y/N)
=> Requirement of Search Functionality (Y/N)

=> Search Usage (Heavy/Average)
Heavy - Using Customised/Enhanced Search/Federated Search
Heavy - Support for searching external data stores.
Average - Out of the box Search Functionality

=> Use of InfoPath Services and Excel Services (Y/N)
=> Usage of MySites (Y/N)
=> Usage of Business Data Catalog (Y/N)

=> Sites Redundancy/Failover Requirements?
=> Plan to Customize SharePoint Sites (Y/N)

=> Support for Multiple Language (Y/N)

=> Recovery Server Hardware and then restore sites on Production site.

Note: Some questions may not relate exactly to the hardware, but it will depand on performance suggesting to add more WFE servers to the FARM or no

Glitch after installing Service Pack 2 on MOSS

As usuall Microsoft has done it again and I am not surprised. There is no single patch or Service Pack released by Microsoft which is uncontroversial. Even after Service Pack 2 release of MOSS, it makes sure that they keep getting calls to PSS support.

When you install the 2007 Microsoft Office servers Service Pack 2, the product expiration date is activated incorrectly
http://support.microsoft.com/kb/971620

Link to download WSS 3.0 SP2
http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B&displaylang=en

Link to download SP2 for MOSS 2007
http://www.microsoft.com/downloads/details.aspx?FamilyID=b7816d90-5fc6-4347-89b0-a80deb27a082&displaylang=en

Read more information on SP2
http://technet.microsoft.com/hi-in/office/sharepointserver/bb735839(en-us).aspx

Cannot perform this operation. The file is no longer checked out or has been deleted.

Issue:- You get the error while you check-in a file in SharePoint library.

Resolution:-
1. Site Actions -> Site Settings

2. Go to "Site content types" click on the "Document" content type.

3. The status for the Title column should be "Optional" and not "Hidden".

On MOSS server Contents Site & SSP are using same web application & search is broken

Issue:
In case we use single web application for Content & SSP in MOSS (Microsoft Office SharePoint Server 2007) & search breaks at some point.
We create a new SSP by creating another web application.
Now if we try to change associations to use the newly created SSP,
We are not able to do that because the content site is also a Shared Services "Administration Host"

Resolution:
Last good full farm backup when search was working, if we don't have it

Workaround:
1. As usual start with all possible backups (A full farm backup may fail due to this bad ssp)
2. Backup content databse attached to content site
3. Detach it from existing web application & attach to new web application
(stsadm -o restore may not work)
4. From Central admin>Application Management>Delete Site Collection
5. Delete /ssp/admin site collection
6. IISReset
7. Go to Shared Services Administration & change associations
8. Make new ssp Default
9. Delete old ssp without removing databases
(if we keep old ssp search on new ssp may not work)
10. Run full crawl of content sources & check search after it completes

Note:
We lose old ssp configurations for example Audiences
In case of major issues revert back to last good backup
NOT recommended on Production Servers

Uninstall Microsoft##SSEE (Windows Internal Database Engine which comes with WSS3.0)

Backup all the SQL databases for the Microsoft##SSEE SQL instance
or Copy or rename folder 'C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\ [Uninstall does not remove the folder though :-)]
Run the command below to uninstall that instance:
msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB} callerid=ocsetup.exe

Enable this Form to be filled out by using a browser - checkbox is grayed out while publishing an InfoPath Form

Issue:- "Enable this Form to be filled out by using a browser" checkbox is grayed out while publishing an InfoPath Form.

Even if we try to forcefully Activate the Enterprise Site Collection Feature using stsadm, it does not resolve the issue.

By default when you Browse to the main Site Collection -> View All Site Contents. You should be able to see "Form Templates" by default if the Site Collection "Feature Office SharePoint Server Enterprise Site Features" is Activated.

If the Form Templates is not visible even if "Office SharePoint Server Enterprise Site Features" is Activated then follow the below steps

Resolution:-

1. Open the Main Site Collection in SharePoint Designer.

2. Select the root URL and Right Click -> NEW -> SharePoint Content -> Select Document Library -> Select Form Library -> Under options type the name as "FormServerTemplates". Click on OK.

3. The Library will be created. Right click on "FormServerTemplates" -> Select Properties -> On settings Tab change the name to "Form Templates" and uncheck the option "Use a template for new documents"

4. Click OK. Now you will see the "Form Templates" on the view all site content page.

5. Deactivate and Activate "Office SharePoint Server Enterprise Site Features" once again and now You should be able to publish the InfoPath form with "Enable this Form to be filled out by using a browser" checkbox Enabled.

How to identify the template used to create a site..

hi Friends

I use to wonder in case solution (WSP files) when deployed on the server globally

If the solution are available the sites are also made using those solution . Now I had a Question in my mind that how could I find which templates are bening applied on the site .In case site are moved i.e server is backup is restored over a new server , Creation on new configuration database , Solution are removed etc

At last we end up in getting message

"Page not found' or "Internet Explorer could complete this request " or " Unkown Error"

I created a Aspx file usign the code snipet given below

Code Snippet [ before every tag, '--' is added, you need to remove the hyphens]

==========================================================

<--script type="text/javascript" <--%@ Assembly Name="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"%>
<--%@ Page Language="C#" MasterPageFile="~/_layouts/application.master" Inherits="Microsoft.SharePoint.WebControls.LayoutsPageBase" %>
<--%@ Import Namespace="Microsoft.SharePoint" %>

<--script runat="server">
protected override void OnLoad(EventArgs e){
SPSecurity.RunWithElevatedPrivileges(delegate()
{
using (SPWeb thisWeb = this.Web)
{
lblWebTempalte.Text = thisWeb.WebTemplate;
lblWebTemplateID.Text = thisWeb.WebTemplateId.ToString();
}
});
}
<--/script>
<--asp:Content ID="Main" runat="server" contentplaceholderid="PlaceHolderMain" >

Web Template: <--asp:Label ID="lblWebTempalte" runat="server" />

Web Template ID: <--asp:Label ID="lblWebTemplateID" runat="server" />
<--/asp:Content>

<--asp:Content ID="PageTitle" runat="server" contentplaceholderid="PlaceHolderPageTitle" >
Site Template Information
<--/asp:Content>

<--asp:Content ID="PageTitleInTitleArea" runat="server" contentplaceholderid="PlaceHolderPageTitleInTitleArea" >
Site Template Information
<--/asp:Content>

<--/script>
===========================================================

Web Template: ----->Web Template ID:

============= ================

ABSENCE ----> Absencevacationschedule ----> 75811

PROJMULTI ---->Budgetingtrackingmultipleprojects ----> 75819

BT ----> Bugdatabase ----> 75801

CALLCENTER ---->Callcenter ---->75812

PROJCHANGE ---->Changerequest ----> 75818

COMPROC ---->Complianceprocesssupport ---->75813

DR ---->Documentlibraryreview ---->75803

EVENTPLAN ----> Eventplanning ---->75814

EXREPORTS ---->expensereimbursementapproval ----> 75815

HELPDESK ---->HELPDESK ---->75816

IT ---->InventoryTracking ---->75804

ITTEAM ---->ITTeamWorkspace ---->75817

JRIM ---->JobRequisition ---->75805

KB ---->KnowledgeBase ---->75806

LL ---->LendingLibrary ---->75807

PATM ---->PhysicalAssetTracking ---->75808

PROJSING ---->ProjectTrackingWorkspace ----> 75820

RER ---->RoomEquipmentReservations ---->75809

ST ---->SalesLeadPipeline ---->75810

List of Out of the box MOSS 2007 Template ID Information

========================================================

NAme ---->Web Template: ----> Web Template ID:

============= ================

GLOBAL ---->Global template" ----> 0

STS ---->Team Site,Blank Site,Document Workspace ----> 1

MPS ---->Basic Meeting Workspace ----> 2

MPS ---->Blank Meeting Workspace ---->2

MPS ---->Decision Meeting Workspace ---->2

MPS ---->Social Meeting Workspace 2

MPS ---->Multipage Meeting Workspace 2

CENTRALADMIN ---->Central Admin Site ----> 3

WIKI ---->Wiki Site ---->4

BDR ---->Document Center ----> 7

BLOG ---->Blog ---->9

SPS ---->SharePoint Portal Server Site ---->20

SPSPERS ---->SharePoint Portal Server Personal Space ---->21

SPSMSITE ---->Personalization Site ---->22

SPSTOC ---->Contents area Template ----> 30

SPSTOPIC ---->Topic area template ---->31

SPSNEWS ---->News area template ---->32

SPSNHOME ---->News Home template ---->33

SPSSITES ---->Site Directory area template ----> 34

SPSCOMMU ---->Community area template ---->36

SPSREPORTCENTER ----> Report Center Site" ---->38

CMSPUBLISHING ---->Publishing and Team Collaboration Site ----> 39

OSRV ----> Shared Services Administration Site ----> 40

SPSPORTAL ---->Corporate Intranet Site ---->47

SRCHCEN ---->Search Center ---->50

PROFILES ---->Profiles ----> 51

BLANKINTERNETCONTAINER ---->Internet Presence Web Site ---->52

BLANKINTERNET ---->Publishing Site ---->53

BLANKINTERNET ---->Press Releases Site ---->53

BLANKINTERNET ---->Publishing Site ---->53

SPSMSITEHOST ----> My Site Host ---->54

SRCHCENTERLITE ----> Search Center Lite ---->90

PWA ---->Project Web Access Site ----> 6221

PWS ----> Project Workspace ---->6215

OFFILE ----> Records Repository ----> 1483

OFFILE---->Records Repository ---->14483

To find out how many Solutions are deployed on the server we can achieve by

Central administration > operation> solution management

We would be finding the List of WSP file or Cab files installed

To find the solution from the Configuration database to you configuration database (Eg Wss_config)

Go to the databases open the table Dbo.objects .you would be finding the List of Solution in inside the tables

Note:- Above Steps would be senario Specfic .before doing any step Its advisable to take a full farm back and Sql back up to be on safe side

Full farm Backup (GUI)

hi Friends
Recently I faced a issue related to Full farm backup .When I use to take a Full farm backup we use to get error
"object (database name) failed in event OnBackup. for more information, see the error log located in the backup directory. sqlException: BACKUP DATABASE is terminating abnormally.

Digging more in to the issue we came accross many settings. but the one thats solved the problem was a registry entry
We added the registry key “SessTimeout” at the location HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters.
We gave the value as 360 for SessTimeout

Here is the article you can check
http://support.microsoft.com/default.aspx?scid=kb;EN-US;102981

Schedule Automatic WSS3.0 Backups

Back up a farm by using the Stsadm command-line tool (Windows SharePoint Services 3.0)
http://technet.microsoft.com/en-us/library/cc288541.aspx

Back up a farm by using SQL Server Tools (Windows SharePoint Services 3.0)
http://technet.microsoft.com/en-us/library/cc288402.aspx

How to schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005
http://support.microsoft.com/?kbid=930615

Restore a farm after a configuration database problem (Windows SharePoint Services)
http://technet.microsoft.com/en-us/library/cc512814.aspx