Monday, December 13, 2010

Fixing 'Feature {Guid} for list template is not installed in this farm. The operation could not be completed'.

Project Description

The ListInstanceFix tool is a SharePoint 2007 tool that provides an easy way to discover all the list instances in a SharePoint site which were created from a list template, but this list template doesn't exist in SharePoint anymore. This is making SharePoint to throw the following exception when a user navigates to the list: Fixing 'Feature {Guid} for list template is not installed in this farm. The operation could not be completed'.

Thursday, November 4, 2010

Windows Server 2008R2 VMs Shut Down After 1 to 2 Hours

When created a lab environment to test ADFS 2.0 I utilized the Windows 2008R2 VM baselines distributed by Microsoft.  After a few days I was told that I had to activate.  The VMs included a 180 day license for use but I didn't feel like adding another network adapter into Hyper-V to connect them to the internet.  I started having issues though where the servers would shut down every hour or so.  I though that maybe there was a memory issue and Hyper-V was shutting them down in order to free up RAM.  Turns out that if Server 2008R2 is not activated it automatically shuts down after a period of time.  After connecting the server to the internet and activating them the problem went away.

Finally the madness of the unknown shut downs has ended :)

Tuesday, November 2, 2010

Collapse All Visual Studio Projects - PowerCommands

Tired of opening up a Visual Studio Solution and having to deal with collapsing all the project manually.  Check out PowerCommands, it's free and offer these additional features.

Visual Studio 2008:
Visual Studio 2010:

Enable/Disable PowerCommands in Options dialog

This feature allows you to select which commands to enable in the Visual Studio IDE. Point to the Tools menu, then click Options. Expand the PowerCommands options, then click Commands. Check the commands you would like to enable.

Note: All power commands are initially defaulted Enabled.

Format document on save / Remove and Sort Usings on save
The Format document on save option formats the tabs, spaces, and so on of the document being saved. It is equivalent to pointing to the Edit menu, clicking Advanced, and then clicking Format Document. The Remove and sort usings option removes unused using statements and sorts the remaining using statements in the document being saved.

Note: The Remove and sort usings option is only available for C# documents.

Note: Format document on save and Remove and sort usings both are initially defaulted OFF.

Clear All Panes
This command clears all output panes. It can be executed from the button on the toolbar of the Output window.

Copy Path
This command copies the full path of the currently selected item to the clipboard. It can be executed by right-clicking one of these nodes in the Solution Explorer:

The solution node; A project node; Any project item node; Any folder.

Email CodeSnippet
To email the lines of text you select in the code editor, right-click anywhere in the editor and then click Email CodeSnippet.

Insert Guid Attribute
This command adds a Guid attribute to a selected class. From the code editor, right-click anywhere within the class definition, then click Insert Guid Attribute.

Show All Files
This command shows the hidden files in all projects displayed in the Solution Explorer when the solution node is selected. It enhances the Show All Files button, which normally shows only the hidden files in the selected project node.

Undo Close
This command reopens a closed document , returning the cursor to its last position. To reopen the most recently closed document, point to the Edit menu, then click Undo Close. Alternately, you can use the CtrlShiftZ shortcut.

To reopen any other recently closed document, point to the View menu, click Other Windows, and then click Undo Close Window. The Undo Close window appears, typically next to the Output window. Double-click any document in the list to reopen it.

Collapse Projects
This command collapses a project or projects in the Solution Explorer starting from the root selected node. Collapsing a project can increase the readability of the solution. This command can be executed from three different places: solution, solution folders and project nodes respectively.

Copy Class
This command copies a selected class entire content to the clipboard, renaming the class. This command is normally followed by a Paste Class command, which renames the class to avoid a compilation error. It can be executed from a single project item or a project item with dependent sub items.

Paste Class
This command pastes a class entire content from the clipboard, renaming the class to avoid a compilation error. This command is normally preceded by a Copy Class command. It can be executed from a project or folder node.

Copy References
This command copies a reference or set of references to the clipboard. It can be executed from the references node, a single reference node or set of reference nodes.

Paste References
This command pastes a reference or set of references from the clipboard. It can be executed from different places depending on the type of project. For CSharp projects it can be executed from the references node. For Visual Basic and Website projects it can be executed from the project node.

Copy As Project Reference
This command copies a project as a project reference to the clipboard. It can be executed from a project node.

Edit Project File
This command opens the MSBuild project file for a selected project inside Visual Studio. It combines the existing Unload Project and Edit Project commands.

Open Containing Folder
This command opens a Windows Explorer window pointing to the physical path of a selected item. It can be executed from a project item node

Open Command Prompt
This command opens a Visual Studio command prompt pointing to the physical path of a selected item. It can be executed from four different places: solution, project, folder and project item nodes respectively.

Unload Projects
This command unloads all projects in a solution. This can be useful in MSBuild scenarios when multiple projects are being edited. This command can be executed from the solution node.

Reload Projects
This command reloads all unloaded projects in a solution. It can be executed from the solution node.

Remove and Sort Usings
This command removes and sort using statements for all classes given a project. It is useful, for example, in removing or organizing the using statements generated by a wizard. This command can be executed from a solution node or a single project node.

Extract Constant
This command creates a constant definition statement for a selected text. Extracting a constant effectively names a literal value, which can improve readability. This command can be executed from the code editor by right-clicking selected text.

Clear Recent File List
This command clears the Visual Studio recent file list. The Clear Recent File List command brings up a Clear File dialog which allows any or all recent files to be selected.

Clear Recent Project List
This command clears the Visual Studio recent project list. The Clear Recent Project List command brings up a Clear File dialog which allows any or all recent projects to be selected.

Transform Templates
This command executes a custom tool with associated text templates items. It can be executed from a DSL project node or a DSL folder node.

Close All
This command closes all documents. It can be executed from a document tab.

Monday, October 25, 2010

CryptographicException Error Connecting SharePoint 2007 and ADFS 2.0 Using Domain App Pool User with SharePoint

When attempting to connect ADFS 2.0 and SharePoint 2007 most of the documentation assumes you are using the NetworkService account to run the application pools for the SharePoint content web applications.  In a real world environment though a domain user is probably running the app pools.

Tech Specs:

SharePoint Version: 2007
ADFS Version: 2.0
Server OS: 2008R2

ADFS URL: https://lab-adfs.defenseready.local/
SharePoint 2007 URL: https://ext.defenseready.local/
SharePoint App Pool User: defenseready\spapppool

What Happens:

Users opens the browser and navigates to the site.

Enter user information and click Sign In

The user now is presented with the error that An unexpected error has occurred.

How to diagnose:

In order to diagnose we will need to update the web.config for the SharePoint site.

First find the CallStack attribute and set it to true
Secondly change the customErrors mode attribute to Off

When we repeat the steps earlier and try to access the site we can now see the full error.

SharePoint is reporting a CryptographicException

 How to Resolve:

In order to give the application pool the correct rights to load the certificates we need to update the application pool settings.   Specifically we need to update the Load User Profile setting to True.

 After you have updated this restart IIS and give it another try.

Sunday, October 24, 2010

Clean Up IIS and Active Directory After ADFS 2.0 Uninstall

The following is taken from the following KB article:  I have had to do this so many times though I found it easier to post it here :)

The Active Directory Federation Services 2.0(AD FS 2.0) uninstallation wizard uninstalls AD FS 2.0 from your computer. However, you may still have to manually restore or cleanup settings in either of the following situations:

  • When you uninstall AD FS 2.0 from a federation server or federation server proxy computer, the uninstall wizard does not restore IIS to its original state.
  • When you uninstall AD FS 2.0 from the last added federation server in a federation server farm, the uninstall process does not delete the certificate sharing container that was created in Active Directory.
Restore IIS on a federation server or federation server proxy computer

When AD FS 2.0 is installed on a computer that is configured for the federation server or federation server proxy role, it will create the /adfs and /adfs/ls virtual directories in IIS. AD FS 2.0 will also create a new application pool named ADFSAppPool. When you uninstall AD FS 2.0 from a federation server or federation server proxy computer, these virtual directories are not removed. Additionally, the application pool is not removed. This can create problems if AD FS 2.0 is installed again on the same computer.

To manually remove these directories from the decommissioned federation server or federation server proxy computer, follow these steps:

  1. Click Start, select Administrative Tools, and then select IIS Manager.
  2. Expand the server name node, expand Sites, and then select Default Web Site.
  3. In the Actions pane, select View Applications.

    Note: You should see the following two virtual directories associated with AD FS 2.0:
  4. Right-click the AD FS 2.0 application that is in each virtual directory, and then click Remove.
  5. In the Actions pane, select Application Pools.

    Note: You should see an application pool named ADFSAppPool.
  6. Right-click ADFSAppPool, and then select Remove.

    Note: The next two steps show how to remove the \adfs directory from the "inetpub" directory. If you have made custom changes to the content within this directory, we recommend that you back up this content to another location before removing the directory.
  7. In Windows Explorer, browse to the "inetpub" directory. This directory is usually located in the following path:
  8. Right-click the Adfs directory, and then click Delete
Delete the certificate sharing container in Active Directory

When you install AD FS 2.0 and use the Federation Server Configuration Wizard to create a new Federation Server in a new Federation Server farm, the wizard will create a certificate sharing container in Active Directory. This container is used by all the federation servers in the farm. When you uninstall AD FS 2.0 from the last added federation server in a farm, this container is not deleted from Active Directory.

To manually delete this container in Active Directory, follow these steps:

  1. Before you remove AD FS 2.0 from the last federation server in the farm, run the following PowerShell commands on the AD FS 2.0 STS to determine the location of the certificate sharing container in Active Directory:
    • Add-PsSnapin Microsoft.Adfs.Powershell
    • Get-AdfsProperties
  2. Note: the CertificateSharingContainer property in the output from the previous step.
  3. Log on to a server where the ADSIEdit tool (ADSIEdit.msc) is installed.
  4. Click Start, click Run, type ADSIEdit.msc, and then press ENTER.
  5. In the ADSIEdit tool, connect to the Default naming context by following these steps:
    1. Right-click ADSI Edit, and then click Connect to.
    2. Under Connection Point, click Select a well-known Naming Context, and then select Default naming context.
    3. Click OK.
  6. Expand the following node:
    Default naming context, {your domain partition}, CN=Program Data, CN=Microsoft, CN=ADFS
    Note: Under CN=ADFS, you see a container named CN={GUID} for each AD FS 2.0 farm that you have deployed, where {GUID} matches the CertificateSharingContainer property that you captured by using the Get-AdfsProperties PowerShell command in step 1.
  7. Right-click the appropriate {GUID} container, and then select Delete.

Saturday, October 23, 2010

Display ADFS 2.0 Forms Authentication Login Page Instead of Windows Authentication Prompt

After installing ADFS 2.0 for SharePoint a Windows login prompt was shown when the SharePoint site forwarded to the ADFS server instead of the ADFS Forms Authentication login screen. 

No matter what account I tried to use here I would eventually receive a 401 Not Auhorized error.

The reason for this is that the ADFS website tries to use Windows Authentication before trying to use the Forms authentication which displays the loging page below.

Forms Login Screen for ADFS 2.0

To fix this do the following on the ADFS server:

1. Open IIS and Explore under Default Website\adfs\ls

2. Open the web.config file with Notepad, look for the localAuthenticationTypes section.

3. Move the line for Forms above the line for Integrated and save the web.config file.  This will force the ADFS application to use the Login Page authentication before trying to use Windows Authentication.


Thursday, October 21, 2010

Install XPS Viewer for Windows Server 2008R2

If you need to install the XPS viewer on Windows Server 2008R2 just follow these directions.

1. Open the Server Manager for the computer.

2. Click on Add features.

  3. Scroll down to the XPS Viewer selection and click the check box.

 4. Click the Install button.

 5. After the installation has completed click the Close button.

Thursday, September 30, 2010

Using SQL Server 2005/2008 with ADFS 2.0

If you plan on using a SQL server 2005/2008 to host your ADFS 2.0 configuration database you must run the configuration using the command line.  If you use the GUI configuration SQL Server Express will be installed on the machine and used to host the database.

Below is an example of a configuration command that would set the service account, create the database and wipe out any information if it already exists, and to use self signed certificates.

Open a command prompt and navigate to:
C:\Program Files\Active Directory Federation Services 2.0

Run the following command:
FSConfig.exe CreateSQLFarm /ServiceAccount "domain\user" /ServiceAccountPassword "password" /SQLConnectionString "database=AdfsConfigurationServer;server=sqlservername;integrated security=SSPI" /port 443 /FederationServiceName "" /CleanConfig /AutoCertRolloverEnabled

Here is an example of my lab configuration:

Finally, the help information is only available through the command line. below is a screen shot of the full output.

MSDN - Configure a New Federation Server

Monday, September 27, 2010

CRM 4 to 2011 Javascript Converter

Project Description:
CRM 4 to CRM 2011 Javascript Converter helps convert scripts to the latest CRM 2011 Form scripting model. The converter uses an xml file that contains CRM4 and CRM5 nodes which allow the converter to find/replace specific instances of text.

Simply paste your CRM 4 script into the left hand text area and click Convert.

Thursday, September 23, 2010

Errors Adding a Server to the Farm - Invalid List Template (0x8102007B)

Attempting to run the SharePoint Products and Technology Configuration Wizard on a server to add it into the farm.  Our farm also has customized site and list definitions.

During the configuration an error was displayed stating that there was an 'Invalid List Template' and to check to logs for more errors.  The Windows Application logs revealed a Event 104 error with the details showing a System.Runtime.InteropServices.COMException error which also identified an Invalid List Template as well the error code, 0x8102007B.

Run the SharePoint Products and Technology Configuration Wizard on the machine you attempted to add and remove it from the SharePoint farm.  (This is done because the Invalid List Template error does not cause the wizard to roll back the installation it just leaves a semi-broken installation in place.)

Log into a machine already attached to the SharePoint farm and navigate to the following directory.

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\1033\XML

Copy all the files located in this directory and past them into the same directory in the server you are attempting to add to the farm.

Run the SharePoint Products and Technology Configuration Wizard again.

Monday, September 20, 2010

Coming Soon - Sabbath Night in the Church of the Piranha

Coming soon to the stage of Taking Flight Theatre Company is Sabbath Night in the Church of the Piranha. I will be there the opening Friday, October 8th @ 8PM .  There will also be a talk back with the author that night which will make it even more interesting.  I hope to see you all there.

Show Information

Written by Edward Falco
Directed by Haley Murphy

SPECIAL EVENT: Talk back with the Author, Edward Falco, is scheduled for October 8th, immediately following the performance!

Waddell Theater on NOVA’s Loudoun Campus
1000 Harry Byrd Highway
Sterling, VA 20164

It is Sabbath Night in the Church of the Piranha — a church created by 15-year-old Chris Penrose as a way to prove to his mother, Una, that he is an adult and capable of running his own life. When Una’s mother Marilyn arrives for a surprise visit, the Sabbath ceremony takes a backseat to the drama that arises as Chris argues his independence from Una while Una attempts to maintain the emotional and physical balance she has worked so hard to keep in spite of Marilyn’s constant criticism and Chris’s teenage angst.

This original work by Virginia Tech English professor Edward Falco is an intense character-driven piece that examines the relationship between parent and child as children strive to be independent from their mothers’ hold over them.

UNA – Marianne Meyers
MARILYN – Mary Jo Levesque
CHRIS – Wayne Jacques
PATTY – Allegra Joffe

Click Here to Purchase Tickets

Friday, August 27, 2010

DLL Will Not Load in FxCop on Windows Server 2008

I was attempting to install the SharePoint dispose checker into my FxCop program using the rules dll found here,  After getting everything install I tried running FxCop and received the getting an error that the application could not properly load the assembly.


-Close FxCop

-Right click on the SPDisposeCheckRules.dll and go to the properties of the file.

-Click the 'Unlock' button on the General tab of the properties form.

-Fun FxCop again and the error should be gone.

Friday, August 20, 2010

SharePoint List Definition Exporter

I was looking to create a schema file for a list I currently have in SharePoint.  If you have done this before you can understand the pain.  In my searches though I came across a great tool on Codeplex which offers the ability to export the schema.xml file for a list you currently have in SharePoint.

Imtech StsAdm Commands v1.0.0.0

Additional I found a great article on creating the definition and code for deploying a list using a feature receiver.

Thursday, July 22, 2010

SharePoint Server State Service

After adding the SharePoint 2010 Chart Web Part to a page I received an error that the Server State Service had not been configured.  Apparently this service is not installed unless you do the simple SharePoint install or use the service setup wizard (which you should never use).  This service application is also used for InfoPath forms services and some of the Visio services which are not set up to use Silverlight.

After reviewing the Central Administration console I soon realized this service application cannot be created in the UI so I lookup up the article to use PowerShell, here it is:

To create the service open a SharePoint PowerShell command windows from Start -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Management Shell
Here are the three basic commands you will need to create the service application and associated database.

$serviceApp = New-SPStateServiceApplication -Name "<StateServiceName>"

New-SPStateServiceDatabase -Name "<StateServiceDatabase>" -ServiceApplication $serviceApp

New-SPStateServiceApplicationProxy -Name "<ApplicationProxyName>" -ServiceApplication $serviceApp -DefaultProxyGroup

Also here is a screenshot of the output I received:

After the service was up and running the Chart Web Part started working great.

Tuesday, July 20, 2010

Where did my Collaboration Portal go in SharePoint 2010?

When I went to create my first site collection in SharePoint 2010 I was surprised to find there was no site template for the Collaboration Portal.  Apparently it is still there but not on the list of site templates.  If you would like to use the template you will need to create the site using PowerShell.  Below is the command to create a site collection using the Collaboration Portal template.

New-SPSite -Url http://<url of Site> -OwnerAlias <domain>\<user> -Name “The Wils” -Template SPSPORTAL#0

Sources: (Where I discovered this information) great article on choosing what site template is best for you and also what the site template IDs are for your PowerShell scripts)

Friday, July 9, 2010

PowerShell Script for Delete SharePoint Designer Cache

I have developed several workflow activities for use within SharePoint designer.  Every time a SharePoint Designer workflow is opened a copy of the deployed DLL is downloaded into the WebSiteCache folder in the user profile.  If the DLL is redeployed and the cache is not cleared out errors will be detected when attempting to re-save the workflow.  In order to fix this I have created a simple PowerShell script that will determine the location of the cache directory and delete it.  It will also detect if SharePoint designer is currently running.  It is required that Designer be closed in order to delete the cache directory.

# This script will determine the current user and delete the
# WebSiteCache folder which hold temporary data used by SharePoint
# Designer.

if(Get-Process 'SPDESIGN' -ea SilentlyContinue)
    "Please close SharePoint Designer before running this script."
    $username = $env:USERNAME
    if (Test-Path C:\Users\$username\AppData\Local\Microsoft\WebsiteCache)
        "Directory Exists Removing Contents for $username"
        Remove-Item C:\Users\$username\AppData\Local\Microsoft\WebsiteCache -force -recurse
        "Directory Does Not Exist for $username"

Thursday, July 8, 2010

Remove Timeout When Debugging w3wp Process

One of the smart guys I work with posted some information about debugging the W3WP process that I though I should share. Many times when debugging this process I get timeout errors when I let it sit for too long.

Error: The web server process that was being debugged has been terminated by Internet Information Services (IIS)

You can get rid of the timeout by following the following directions. Caution, this should only be done on development boxes, do not change these settings on your production machines.

  1. Open the Administrative Tools window.
  2. Click Start and then choose Control Panel.
  3. In Control Panel, choose Switch to Classic View, if necessary, and then double-click Administrative Tools.
  4. In the Administrative Tools window, double-click Internet Information Services (IIS) Manager.
  5. In the Internet Information Services (IIS) Manager window, expand the node.
  6. Under the node, right-click Application Pools.
  7. In the Application Pools list, right-click the name of the pool your application runs in, and then click Advanced Settings.
  8. In the Advanced Settings dialog box, locate the Process Model section and chose one of the following actions:
    • Set Ping Enabled to False. —or—
    • Set Ping Maximum Response Time to a value greater than 90 seconds.
  9. Setting Ping Enabled to False stops IIS from checking whether the worker process is still running and keeps the worker process alive until you stop your debugged process. Setting Ping Maximum Response Time to a large value allows IIS to continue monitoring the worker process.
  10. Click OK.

Thursday, July 1, 2010

SharePoint Kerberos Authentication wtih IIS 7+

When Microsoft designed IIS 7 they decided to add in a new feature that automaticaly uses the LocalSystem account for Windows Authentication by the kernel.  The problem with this is that is causes problems when a domain account is being used for the SharePoint applicaiton pools and Kerberos is enabled.  Because the authenication is happening as LocalSystem the application pool account is desregarded when it comes to kerberos.

When I had kerberos enabled and the kernel-mode authentication was enabledI would get prompted for user credentials until finally receiving a 401 error in the browser.


There are two ways to fix this issue.  You can fix it for all websites or for a specific website.  The first solution is to apply to all websites.

Apply to all sites:
Right click on Notepad and choose "Run as administrator"

Navigate to and open: C:\Windows\System32\inetsrv\config\applicationHost.config

Under the system.webServer/security/authentication/windowsAuthentication section ensure the following.

<windowsauthentication enabled="true" useapppoolcredentials="true" usekernelmode="true">

Apply to individual site:
The second way will allow you to apply this change to a specific website.

Open the IIS Manager and click on the website you would like to change.  Then double click on the Authentication icon in the center pane.

Click on the Windows Authentication option in the center pane and then click Advanced Settings... in the right hand pane.

Finally un-check the Enable Kernel-mode authentication box.

Supporting Post(s):

Microsoft Forefront Client Install Wihtout Centralized Server

I was recently looking around for an Anti-Virus solution for Windows Server 2008.  I had tried downloading Microsoft Forefront Client before but when I ran the setup it wanted me to install a ton of server components... so where is the client part of all this?  What I wanted was a simple anti-virus software that uses windows update to get all my new virus definitions.

To do this just run the install the client from the cd using the /NOMOM switch.  This install the client but uses Windows Update to get all the virus definitions.

Open a Command Prompt using the "Run as administrator" option.  Then run one of the following commands based upon your server OS being 32 or 64 bit.




Wednesday, June 30, 2010

Add User As Local Administrator On Domain Controller

I recently was settting up a new Microsoft SharePoint 2010 machine and had promoted the machine to a domain controller before creating my SharePoint admin accounts.  I needed to add several of my accounts to the local Administrators group.  Unfortunately after you promote a server to a domain controller you can no longer access the GUI for Local Users and Groups.  Instead I had to use the command line to add the users.

Open a command promt using the "Run as administrator" function and then run the following command.

net localgroup Administrators /add {domain}\{user}

Note: do not include the {} brackets.

Tuesday, May 25, 2010

Evil Dead The Musical

Evil Dead The Musical

Evil Dead The Musical starts this Friday, May 28th, at the Loudoun campus of NOVA. If you loved the movie The Evil Dead or if you just love cheesy horror movies you will enjoy this show. As the Technical Director for the show I am extremely excited by all the hard work and dedication put in by the entire crew to see this technically challenging show come together in all its splendidly bloody goodness. Enjoy the show!

Rating: (R) for simulated violence and strong language.

Based on Sam Raimi’s 80s cult classic films, EVIL DEAD tells the tale of 5 college students who travel to a cabin in the woods and accidentally unleash an evil force. And although it may sound like a horror story, it’s not! The songs are hilariously campy and the show is bursting with more farce than a Monty Python skit. EVIL DEAD: THE MUSICAL unearths the old familiar story: boy and friends take a weekend getaway at abandoned cabin, boy expects to get lucky, boy unleashes ancient evil spirit, friends turn into Candarian Demons, boy fights until dawn to survive. As musical mayhem descends upon this sleepover in the woods, “camp” takes on a whole new meaning with uproarious numbers like “All the Men in my Life Keep Getting Killed by Candarian Demons,” “Look Who’s Evil Now”, and “Do the Necronomicon”.

The Movie, The Evil Dead:
-Info on the Movie:
-If you have Netflix you can watch the movie instantly on your computer:
May 28, 29, 30, June 4, 5, 6, 11, 12
Fridays and Saturdays at 8PM and Sundays at 7pm.

We are selling a lot of tickets so I would suggest ordering ticket ahead of time.
Click here to Purchase Tickets

Splatter Zone:
You may upgrade your ticket to splatter zone for $2 at the door. It is first come, first served.

Waddell Building
NOVA Loudoun Campus
1000 Harry Byrd Highway
Sterling, VA 20164
Google Map »
The theatre is located just inside either entrance to the Waddell Building, on your right from the West entrance and on your left from the South entrance past the loading dock.

Monday, May 17, 2010

SharePoint Event ID 6481 Fix

Event  Properties:

- Provider
[ Name] Office SharePoint Server
- EventID 6481
[ Qualifiers] 0
Level 2
Task 1328
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2010-05-13T17:11:13.000000000Z
EventRecordID 50233
Channel Application
Computer <>

Microsoft.Office.Server.Search.Administration.SearchDataAccessServiceInstance (ae360320-4426-488b-9757-844f84dd7904).

Reason: An update conflict has occurred, and you must re-try this action. The object SearchDataAccessServiceInstance Parent=SPServer Name=<> is being updated by <>\<>, in the OWSTIMER process, on machine <>. View the tracing log for more information about the conflict.

Techinal Support Details:

Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException: An update conflict has occurred, and you must re-try this action. The object SearchDataAccessServiceInstance Parent=SPServer Name=<> is being updated by <>\<>er, in the OWSTIMER process, on machine <>. View the tracing log for more information about the conflict.

at Microsoft.SharePoint.Administration.SPConfigurationDatabase.StoreObject(SPPersistedObject obj, Boolean storeClassIfNecessary, Boolean ensure)
at Microsoft.SharePoint.Administration.SPConfigurationDatabase.PutObject(SPPersistedObject obj, Boolean ensure)
at Microsoft.SharePoint.Administration.SPPersistedObject.Update()
at Microsoft.SharePoint.Administration.SPServiceInstance.Update()
at Microsoft.Office.Server.Search.Administration.SearchDataAccessServiceInstance.Synchronize(Boolean bCalledFromSSI)
at Microsoft.Office.Server.Administration.ApplicationServerJob.ProvisionLocalSharedServiceInstances(Boolean isAdministrationServiceJob)

The Fix:

Friday, May 7, 2010

Errors Saving and Checkin In Excel/PowerPoint files in SharePoint using CAC Card

Users accessing SharePoint using a CAC card may experienced problems with saving and checking in Excel and PowerPoint documents on the SharePoint servers.  When attempting to do either a dialog box appeared stating that "The web server is currently busy please try again later."

-Office 2007
-Server 2008
-SharePoint 2007 SP2
-IIS 7.5

The problem turned out to be that a setting, uploadreadaheadsize, is defaulted to 48kb.  This is not big enough for the website to read in the entire header when a CAC certificate is added to it.  To fix the problem I completed the following steps.

1. Start->Run-> runas /user:Administrator cmd
cd c:\Windows\systems32\inetsrv

2. appcmd.exe set config  -section:system.webServer/serverRuntime /uploadReadAheadSize:"200000000"  /commit:apphost

This updates IIS to ensure it can read all the data in the headers.

Supporing Posts:

Thursday, April 22, 2010

SharePoint Anonymouse Access Web Part Targeting

LoginView Control
This control can be used to show content based upon if a users is anonymous or logged in.    In the case below the word “test” would be shown for anonymous users.

-This would just need to be added to the layout page which is being used for the main portal page.

-You cannot put a web part or webpart zone within the control only html which mean you could not use to target web parts to users only html code.
-You cannot edit the content within the browser any updates to your content need to be done in a text editor and pushed to the server during a release.
<tr ID="TopRow" style="padding-top: 6px;padding-right: 6px;padding-left:6px;padding-bottom: 18px;">
 <td valign="top" ID="TopCell" width="100%" colspan="3">
  <asp:LoginView id="LoginView1" runat="server">               
    <div>Show to Anonymous User</div>
    <div>Show to Logged In User</div>

SP Security Trimmed Control
This control is great for hiding webparts from anonymous users but not from hiding them from logged in users.

-This would just need to be added to the layout page which is being used for the main portal page.

-Does not hide webparts from logged in users.
<sharepoint:spsecuritytrimmedcontrol runat="server" permissionsstring="CreateSSCSite">
<webpartpages:webpartzone runat="server" frametype="TitleBarOnly" id="Left" title="loc:Left">
<webpartpages:imagewebpart runat="server" verticalalignment="Middle" allowedit="True" allowconnect="True" connectionid="00000000-0000-0000-0000-000000000000" title="Site Image" isincluded="True" dir="Default" backgroundcolor="transparent" isvisible="True" alternativetext="Microsoft Windows SharePoint Services Logo" allowminimize="True" exportcontrolledproperties="True" zoneid="Left" id="g_60b6aa26_dd7b_4973_aaa0_ece2f2110920" horizontalalignment="Center" imagelink="/_layouts/images/thumbsup.jpg" exportmode="All" allowhide="True" suppresswebpartchrome="False" chrometype="None" framestate="Normal" missingassembly="Cannot import this Web Part." allowremove="True" helpmode="Modeless" frametype="None" allowzonechange="True" partorder="1" description="Use to display pictures and photos." __markuptype="vsattributemarkup" __webpartid="{60B6AA26-DD7B-4973-AAA0-ECE2F2110920}" webpart="true"></webpartpages:imagewebpart>

SharePoint Anonymous Audience Feature
This is a feature build for SharePoint which adds a check box under the audience settings in all webparts to allow you to directly target them to anonymous users.

-Is automatically integrated into all webparts so it can be used everywhere.
-Web part configuration is done through the browser which means changing a webpart does not require a redeployment.
-When you are logged in and viewing the page in design mode you can still see the webparts that are targeted to anonymous which you are unable to do with the other solutions.

Because it is a coded solution it may require review by a Change Control Board before deploying to server.

Thursday, April 8, 2010

Cannot Access SharePoint From The Server

Accessing sharepoint using the FQDN while on the server.

There is a registry setting to disable the Loopback Adapter that is present in Windows Server.  I have found this to cause a lot of errors not only with accessing the SharePoint site but also with indexing and searching.  I typicaly suggestion making the following registry settings after installing any instance of Microsoft SharePoint or Microsoft SQL server.

To set the DisableLoopbackCheck registry key, follow these steps:

1. Set the DisableStrictNameChecking registry entry to 1. For more information about how to do this, click the following article number to view the article in the Microsoft Knowledge Base:

281308 ( ) Connecting to SMB share on a Windows 2000-based computer or a Windows Server 2003-based computer may not work with an alias name

2. Click Start, click Run, type regedit, and then click OK.

3. In Registry Editor, locate and then click the following registry key:


4. Right-click Lsa, point to New, and then click DWORD Value.

5. Type DisableLoopbackCheck, and then press ENTER.

6. Right-click DisableLoopbackCheck, and then click Modify.

7. In the Value data box, type 1, and then click OK.

8. Quit Registry Editor, and then restart your computer.

Anne Marie in The Producers

My wonderful wife Anne Marie is going to be performing in an upcoming production of The Producers. This is musical written by Mel Brooks, so you know it has to be funny. Anne Marie plays the role of a tall, blond, and super hot Swedish secretary name Ula a role also played by Uma Thurman in the movie version. I will be attending the performance this Saturday, April 10th, and mostly likely some other dates as well. I would love if you could come out and help support Anne Marie in her theatre endeavors. If you are looking for something to do before the show there is a great place called Eat Bar just down the street, . Also if you get to the show and are wondering who the heck is Anne Marie Pinto??? Pinto is her stage name, and also a really awful model of care that Ford put out in the 70's.

Book by Mel Brooks & Thomas Meehan
Music and Lyrics by Mel Brooks

Performance dates:
April 9, 10, 11(m), 16, 17, 18(m), 23 & 24, 2010
(Fridays and Saturdays at 8:00 PM, Sundays at 2:30 PM)

About the Show:
It’s 1959 and perennially unsuccessful Broadway producer, Max Bialystock has opened his latest theater flop. When going over the accounting with his nerdy, young accountant, Leo Bloom, he dreams up a scheme to raise millions of dollars from his rich old lady backers and then put on a flop of a show. With all the money that will be leftover when the show closes after opening night, the pair will be rich. All they need is a bad script, a bad director and the scheme is sure to work. They find what they need: a musical about Adolf Hitler directed by an overblown hack. Only one thing goes wrong: the show is a hit!

Click here to see a clip from the movie:


Ticket prices for The Producers will be:
Adults: $20.00
Seniors (60+) $15.00
Juniors (18-) $15.00
Click here to order:

If you don't have any cash but still want to see the show they are looking for people to usher some of the performances. So no excuses about being poor or too cheap :)

Wednesday, February 24, 2010

CRM Install Problem: instance name must be the same as computer name

Open a query window in the Microsoft SQL Server Management Studio and run the following command.  It will display to you the current name of the SQL server.


Next we will run the following commands.  Replace old_name with the SQL server name you discovered in the sp_helpserver command, and replace new_name with the name of the server.  (include the single quotes our the names)

sp_dropserver 'old_name'
sp_addserver 'new_name', local

Open the SQL Server Configuration Manager and resart the SQL Services.

To deteremine if the update was successful run the following command against the 'master' database.  If the query displays the new_name you assigned to SQL it will be displayed here.  If there is nothing displayed then something went wrong.