Fabian Williams SharePoint Blog

Solving problems with SharePoint day and night

This blog has moved to www.SharePointFabian.com

Goo Day all,

I am no longer posting new blogs here and all blog post that is here has been migrated to the new site. My new blog is http://www.sharepointfabian.com/blog please update your book mark and blog roll if I am on it.


February 11, 2011 Posted by | Uncategorized | Leave a comment

Happy Thanksgiving – I’m Thankful for a great SharePoint Community

This is my final blog on using WordPress, I am thankful for all that WordPress gave me over the years. I am also thankful for FPWeb sponsorship of my New Blog which is located at http://www.SharePointFabian.com/Blog please bookmark that address moving forward please. The root site has more information beyond my blogging http://www.SharePointFabian.com such as event speaking, thing I find interesting etc. Thank you @drewbills for branding it and Thank You @marcykellar for the awesome pics you took of me.

See my latest blog on Managed Accounts in SharePoint 2010 using PowerShell


Happy Thanksgiving All!

November 25, 2010 Posted by | Uncategorized | 1 Comment

A little teaser for Fabian Session at SharePoint Saturday DC Federal at Booz Allen Hamilton McLean

So it is 3 am and I have just finished my Lab, as my Hard Drive died and as usual I am traveling all over the place, I just had the time to get this done. But it is good. Come see my session on Linq to SharePoint http://www.sharepointsaturday.org/dcfederal/meetings/17/LINQtoSharePointWhatisitHowdoIUseit.aspx

Here is a Code Snippet of what I have in store for you


Coding how to aggregate data from SQL Server, Pre Existing List in SharePoint and Console data. with Logic to discriminate


October 16, 2010 Posted by | Uncategorized | Leave a comment

My Experience with @BrianLala SharePoint AutoInstaller – I like it

So… as an avid user of Twitter I noticed a few tweets going back and forth between Spence @Harbars and Brian @BrianLala about this tool on CodePlex called AutoSPInstaller.  I have heard about it in the past but most recently and after speaking to Spence about what he ‘coined’ the Idiot Button i.e. the Farm Configuration Wizard; I have been on the quest to find a way to automate creating Service Accounts after installing the SharePoint bits.  Spence does have a few blogs on the topic which i have used to great success, but in the end PowerShell is there for a reason, i just needed to know how to use it.  As a DEV, I wasnt looking forward to learning PowerShell, though i know I have to, but this #AutoSPInstaller utility allows me to cheat – at least for a time – and I get the best of both worlds.

I felt it necessary to blog my experience because there are at least two gotchas that I am aware of but overall my experience was satisfactory.

So after downloading the tool, the first thing i will encourage you to do is.. yes.. Read the “ReadMe” file that is included. It details what you need to do to fire off the script.  The tool comes with a few XML files that you will have to modify; by that I mean, configure. However, these configuration steps is just a matter of providing nomenclatures for your Databases, your Account Names for Service Accounts, your Passwords for those accounts, and whether you want to install features by indicating 1 or 0 (zero). 

There is a Launch.bat file which executes the PowerShell (*.ps1) file; which inturn interrogates a Setup(optionalfilename).XML file for configuration specifics.  In my modifications to my Setup.XML i also renamed to file to include the NETBIOS name of the Server, this allows me to have a specific file for each server in the Farm.

The First Gotcha I encountered had to do with the Installation of the Bits; the script provides for executing the PreInstaller which does work; however I had an issue whereby one of the packages failed so that didnt allow the SharePoint Install to run after the PreInstaller completed. Basically, the script didnt have a graceful exception rule for instances where the PreInstaller fails.  What I got was a generic error BUT, the script log file did tell me where the error was encountered and I did notice it was in the [Region] for the PreInstaller. So I just ran the AutoInstaller by itself and then re-ran the AutoSPInstaller Launch.bat file

The Second Gotcha I met was right after I executed the batch file.  The error is below in the screen shot.  


The Error isnt that descriptive but after going back to Twitter and on CodePlex I saw that I either had to do one of the following

  1. Do a “Run-As” and run the batch file as an Administrator or
  2. Turn off User Access Control (UAC)

What I found particularly interesting is that  although I ran the file on the SharePoint box; which is where I got the error, it was actually referencing an issue on a separate Box, i.e. the SQL Box 

So, I elected to make the changes to UAC because I also don’t like the interruptions when i am installing products.

After I completed those issues with my mitigation techniques; it was smooth sailing. I have included below some screenshots of the process and the resultant logs


Below is the Command Window iterative logs; which is also captured in a log file



Below are all my Sites that were created. 


So in Conclusion.

You are going to have questions on this blog, the first one may be..Well Fabian “What do i do if I wan to build out a Farm that Includes more than one Server (in-fact I fielded a question on Twitter already on this one)..


the answer is to create another specific Setup[YourNameHere]Inputs.xml file and this time it will JOIN the already created farm rather than create a new Farm.  There are several “If Exist” statement in the PowerShell script that does checks for that. Now though I did this in my Lab fortunately this week, I am on a project where I need to do a Base Install of SharePoint 2010 and I plan to use the tool for that. I will let you know how it goes…

As usual, I welcome any Comments, Questions,


September 19, 2010 Posted by | Uncategorized | 3 Comments

started to use HootSuite thanks @EUSP Ma

started to use HootSuite thanks @EUSP Mark Miller for the tip

January 17, 2010 Posted by | Uncategorized | Leave a comment

Please take this Poll on my SharePoint BCS Sessions

After delivering a few sessions, I am thinking about spliting my SharePoint BCS presentation into two sessions: No-Code(SPD2010) and Code(VS2010)…should I?

December 7, 2009 Posted by | Uncategorized | Leave a comment