PowerApps RAW!

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'. http://splistinstancefix.codeplex.com/

A great walkthough of CRM 2011 features. Microsoft Dynamics CRM 2011 Walkthrough Part 1 View more presentations from Jukka Niiranen .

A great overview of what is new in CRM 2011 Microsoft Dynamics CRM 2011 Walkthrough Part 2 View more presentations from Jukka Niiranen .

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 :)

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: http://code.msdn.microsoft.com/PowerCommands Visual Studio 2010: http://visualstudiogallery.msdn.microsoft.com/en-us/e5f41ad9-4edc-4912-bca3-91147db95b99 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 remo...

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 Error: When we repeat the steps ...

The following is taken from the following KB article: http://support.microsoft.com/kb/982813 .  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 /ad...

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.  

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.

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 "adfsserver.domain.com" /CleanConfig /AutoCertRolloverEnabled Here is an example of my lab configuration: Finally, the help information is only ...

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. Usage: Simply paste your CRM 4 script into the left hand text area and click Convert. http://crm2011scriptconvert.codeplex.com/

Situation: 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. Problem: 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. Fix: 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\Comm...

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 Click here to Purchase Tickets 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! Location: Waddell Theater on NOVA’s Loudoun Campus 1000 Harry Byrd Highway Sterling, VA 20164 Synopsis: 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 ind...

I was attempting to install the SharePoint dispose checker into my FxCop program using the rules dll found here, http://spdisposecheckstatic.codeplex.com/ .  After getting everything install I tried running FxCop and received the getting an error that the application could not properly load the assembly. Fix : -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.

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 http://imtech.codeplex.com/releases/view/10875 Additional I found a great article on creating the definition and code for deploying a list using a feature receiver. http://sharepoint.i-devx.com/lists/creating-custom-lists-definitions-through-features/

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: http://technet.microsoft.com/en-us/library/ee704548.aspx 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...

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: http://technicallead.wordpress.com/2010/05/11/create-collaboration-portal-using-powershell/ (Where I discovered this information) http://www.toddbaginski.com/blog/archive/2009/11/20/which-sharepoint-2010-site-template-is-right-for-me.aspx (A great article on choosing what site template is best for you and also what the site template IDs are for your PowerShell scripts)

I have developed several workflow activities for use within SharePoint designer.  Every time a SharePoint D esigner 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." } else { $ username = $ env : USERNAME if (Te...

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. Open the Administrative Tools window. Click Start and then choose Control Panel. In Control Panel, choose Switch to Classic View, if necessary, and then double-click Administrative Tools. In the Administrative Tools window, double-click Internet Information Services ( IIS ) Manager. In the Internet Information Services ( IIS ) Manager window, expand the node. Under the node, right-click Application Pools. In the Application Pools list, right-click the name of the pool y...

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. Symptom(s): 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. Fix(s): 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/w...

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. 32-bit [CD]:\CLIENT\CLIENTSETUP.EXE /NOMOM 64-bit [CD]:\CLIENT\X64\CLIENTSETUP.EXE /NOMOM

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.

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. Synopsis: 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 an...

Event  Properties: System - 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 < > Security Details: 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,...

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." Environment: -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: http://blogs.msdn.com/rakkimk/archive/2009/03/17/iis7-tweet-1-setting-uploadreadahe...

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. Advantages:  -This would just need to be added to the layout page which is being used for the main portal page. Issues: -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">                  <AnonymousTemplate>     ...

Problem : Accessing sharepoint using the FQDN while on the server. Solution : 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 (http://support.microsoft.com/kb/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 cli...

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, http://www.eat-bar.com/  . 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. THE PRODUCERS 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 (Frida...

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. sp_helpserver GO 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' GO sp_addserver 'new_name', local GO 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. SELECT @@SERVERNAME