Random Thoughts on SharePoint, BI, and .NET

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...

I was doing an install recently and a client happened to have installed the .NET Framework 3.5 SP1 on the servers i was working.  The first environment i installed was a two server environment (1 SharePoint, 1 SQL) and everything was working fine...

I was recently doing an stsadm –o restore to restore a backup and was able to successfully move my production site collection backup to test.  When i went to the site it mostly worked with the exception of one subsite.  One subsite was returning...

UPDATE: This has been resolved by the product team with an updated build.  Problem: I installed the December updates as mentioned here SharePoint Team Blog Post and thought everything would just be as smooth as silk but that expectation was a little...

Was recently working with a client working on backup and came across this error Shared Search Index Completed 11/19/2008 2:04 PM Object Shared Search Index failed in event OnPrepareBackup. For more information, see the error log located in the backup...

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...

Another live MOSS site is out there. http://www.XcelEnergy.com .

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...

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...

I had made a previous post with a small code sample on how to upload report deployment. Now I'm improving that post with a new sample that will automate the report deployment based on an xml file. I will utilize a file called ReportsDefinition.xml to...

Hoping this might be a good topic for some people because i guarantee there are very few people who have been through integrating these products.  I have been working on integrating the two products at a client for the past 5 months so hopefully...

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...

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...

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...

Better late than never - http://support.microsoft.com/kb/939942

If you've been trying to put a transparent image into reporting services and have not been able to make the background transparent i share your pain. Luckily i found a solution. 1. Place a rectangle where you would place the image 2. Place the image...

The following blog has a great step by step on how to install Analysis Services Cubes from the Command Line

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...

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...

I ran into a pretty unique situation with crawl rules and search. Here's what happened... I configured crawl rules to ensure that the crawler does not crawl the internet. I started by adding an inclusion of *://*.somecompany.com/* to include...

Had some install issues turning on SSO, here's what i found... The install instructions on Technet are mostly correct with the caveat that inorder to create the database you have to login as the SSO account to the first server where the service is...

Here's what i encountered in the latest install, hope this benefits the community Error Encountered: Description: The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be found. The local computer may not have the necessary registry...