Installing Office 2010 and SharePoint 2007 on the same box will ruin your day

if you are seeing this error “SPUpgradeException: One or more types failed to load” exception when running configuration wizard” it’s most likely because you installed office 2010 on your SharePoint 2007 box.  I wasn’t able to create web apps or deploy certain features.  I solved the issue by removing Office 2010 and rebooting.  

1

Access Denied with Windows Server 2008 and MOSS when Crawling

So i created a new vm using Windows Server 2008, SharePoint Server 2007 + SP1 + Infrastructure updates.  I’m also using a least priveleged account setup with least priveleged accounts running the individual MOSS Services and app pools.  When I started a crawl of local office sharepoint server sites i noticed i was getting 401’ed…

18

Interesting Kerberos Error Related to SQL Server from MOSS

So we setup Kerberos on SharePoint using one of the many guides out there.  Everything worked great but SQL Server was returning KDC_ERR_S_PRINCIPAL_UNKOWN which is typical.  So we registered an SPN for SQL Server using "Setspn -A MSSQLSvc/sqlboxhostname:1433 domain\sqlserviceaccount" and "Setspn -A MSSQLSvc/sqlboxfqdn:1433 domain\sqlserviceaccount".  Here’s where the fun starts.  We start receiving Cannot generate SSPI…


Programmatically retrieve a list of the file extensions from the SSP Search Service

I recently had to expose the file extensions that we allow search to index outside of SharePoint.  Unfortunately SharePoint does not expose this out of the box.  So i had to write a web service to be deployed in MOSS that would expose the file extension list. Here’s the code I used to accomplish this……

1

Writing to the SharePoint Trace Log in your code

Updated: You should not register the trace provider on every request.  Use a singleton to check for registration. Found a great example on how to write to the SharePoint trace log on msdn.  http://msdn2.microsoft.com/en-us/library/aa979522.aspx.  This is very helpful for doing application instrumentation.  Although there are many apis for doing this in .NET very cool to…

1

SharePoint, DOCTYPE, and Master Pages

SharePoint by default does not support taking IE out of quirks mode.  This is discussed in a great blog entry by Heather Solomon.  Not enforcing a dtd through the DOCTYPE element in the default.master (for example DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN”  “http://www.w3.org/TR/html4/loose.dtd”) Caused me a lot of problems since Height 100% is not honored.  Specifically the…

3

Quick Guide on how to install Reporting Services on its own server/cluster in SharePoint Integration Mode without using Kerberos

Install SQL Server 2005 – Reporting Services Only Install SQL Server Service Pack 2 Install Sharepoint (as WFE)- SKU (Enterprise Edition, Standard,etc..) has to match the other SKUs in the farm Run the Sharepoint Server Configuration (do not add central admin unless you want to) – Not sure if this step is needed but can’t hurt…

4

Automating Report Deployment with Reporting Services in SharePoint Integration Mode

Automating Report Deployment in Reporting Services can be challenging.  SharePoint offers many modes of deployment of files.  Unfortunately the out of the box deployment for SharePoint does not allow for automatic hook up of data sources.  So you can deploy the rdl’s using SPFile upload functions on the SPWeb of your choice but those rdls will exist without…

11

How to connect Filter Web Parts

There an excellent post on this blog (http://blogs.msdn.com/edhild/archive/2007/04/17/how-to-connect-web-parts-during-site-provisioning.aspx) about how to connect Web Parts in sharepoint.  With a little change you can connect filters using the same technique. here’s a sample.  I had runtime errors for duplicate connection from the code in the blog entry from edhild when i called mgr.SPWebPartConnections.Add(conn);.This line is not neccessary…

1