SharePoint 2010

How to delete SharePoint alerts for orphaned (deleted) users–WSS 3.0/SharePoint 2007/2010

An issue came up at my client recently, where our webmaster email account was being flooded with non deliverable email notices. Messages were bouncing back because our SharePoint farm was sending alerts to users and email address that no longer existed. This was on a WSS 3.0 farm, and we don’t have any third party tools (like Axceler’s ControlPoint) to help manage scenarios like this. So, I decided to tackle the problem with PowerShell. Of course the first step in writing a PowerShell script is to...

WSS 3.0 to SharePoint 2010: Tips for delaying the Visual Upgrade

My most recent project has been to migrate a bunch of sites from WSS 3.0 (SharePoint 2007) to SharePoint Server 2010. The users are currently working with WSS 3.0 and Office 2003, so the new ribbon based UI in 2010 will be completely new. My client wants to avoid the new SharePoint 2010 look and feel until they’ve had time to train their users, so we’ve been testing the upgrades by keeping them with the 2007 user interface. Permission to perform the Visual Upgrade One of the first things we noticed...

SharePoint 2010 MSDN Labs

Eric Ligman, from Microsoft, posted a great blog post this week listing all of the SharePoint 2010 Virtual Labs that are available from Microsoft. His blog entry is here: http://blogs.msdn.com/b/mss... He also posted other resources as well. I’ve copied his Virtual Lab links here: SharePoint Server 2010 Virtual Labs MSDN Virtual Lab: SharePoint Server 2010: Introduction...

SharePoint 2010 Client Object Model – CAML Query inaccurate results error

I ran into a frustrating scenario today, while working with SharePoint 2010’s Managed Client Object Model. My application queries a SharePoint document library using the file’s name (the FileLeafRef field). Given that this field is unique, I was expecting only one result with the following code: 1 CamlQuery qry = new CamlQuery(); 2 3 //filter the results to only get back the item with the filename we're looking for 4 qry.ViewXml = string.Format( 5 "<Query><Where>...

Error when trying to access SharePoint 2010 via PowerShell in a new environment

I got this error today while trying to access my new SharePoint 2010 environment via PowerShell: Cannot access the local farm. Verify that the local farm is properly configured, currently available, and that you have the appropriate permissions to access the database before trying again. If I would have just read the error message a little more carefully, I would have realized that I should start by looking at my permissions in SQL – which my account didn’t. This happened because I installed SQL...

Error creating PowerPivot Service Application in SharePoint 2010 (SP1 + June 2011 CU)

A few weeks ago I ran into an error while setting up our test farm. I was creating the service applications and when I got to PowerPivot, I got the following error: I was able to work around this error by using PowerShell to create the service application. Background First, some details of our installation: two web front ends, two application servers, and one SQL server. All are running Windows Server 2008 R2 x64 with Service Pack1. The SQL Server is 2008 R2 with SP1. The SharePoint servers are SharePoint...

SharePoint 2010 Not Indexing OneNote 2010 files

Our SharePoint team at work noticed that our SharePoint 2010 farm wasn’t returning search results based on the contents of OneNote files that were saved in document libraries. I did a little research and found a solution, by putting together steps from different posts. First, some details: we’re running SharePoint 2010 SP1 (with the June 2011 CU) on Windows Server 2008 R2 SP1. However, this issue was seen before we applied the service packs and cumulative updates, so I’m not sure what effect, if...

SharePoint 2010–Error when deleting Content Type In Use

UPDATE! July 8th, 2011 -- I’ve been reading Chris Poteet’s blog for a while (probably since Day of .Net Ohio in 2008 or 2009) and he recently started a new blog covering odd user interface quirks and inconsistencies with SharePoint. He’s titled the blog, Unexpected Error. Well, today Chris was kind enough to mention me for follow Friday on Twitter and I followed the link to his blog again – and was stunned to see that I had written a post this week that is pretty much the same one he wrote two weeks...

Illegal characters for SharePoint 2010 Content Type name

Quick tip: you can’t include a backslash in the name of the SharePoint 2010 Content Type. In fact, there are several illegal characters: \ / : * ? " # % < > { } | ~ & , two consecutive periods (..), or special characters such as a tab. What, you didn’t know that after entering one of these characters in the name? Is it because you saw this screen: Oh, that’s right….you need to turn off custom errors in the layouts folder…See this blog post for details and you’ll also need to turn off for...

SharePoint 2010 Developer Training

I’ve written a couple of posts about SharePoint 2010 Administrator training/learning, so I thought I should follow up with some tips for developer training as well…. Microsoft has two exams for SharePoint 2010 developers. The first is Exam 70-573, Application Development. The second is Exam 70-576, Designing and Developing Microsoft SharePoint 2010 Applications. Those links cover the topics for each exam as well as some Microsoft preparation materials. One of the best sites, and one that I relied...

Full SharePoint 2010 Archive

Twitter