Interested in Writing a Chapter for a SP2010 Community Book

About this book:  This book consists of standalone chapters written by various authors with real world experience of SharePoint 2010.  The content is predominantly non-technical allowing people involved and managing SharePoint 2010 projects to deploy SharePoint successfully within their business.

More info ...

AntiVirus for Windows 2008 Developer Machines or WAF

Problem: My developer machine always runs Windows 2008 R2 x64.  I use the machine to browse the Internet and would like anti-virus installed.  No workstation based anti-virus will install on Windows 2008 Sever.

Initial Hypothesis: All the vendors that provide Anti-virus for Windows 2008 are expensive and are Server based anti-virus software whereas I am using my developer machine to surf and occasionally bring on files so I only need workstation based anti-virus.  Unfortunately I have never found a regular anti-virus that runs on Windows 2008 until now ... and best of all it's free and from Microsoft.

Resolution:  Use "Microsoft Security Essentials"
http://www.microsoft.com/en-gb/security_essentials/default.aspx

List of anti-virus plug ins

Update: 04 Sept 2013 - Antivirus and SharePoint 2013 (Spencer Harbar)

Update: 31 May 2022 - WAF sometimes don't have a anti-virus or cost a lot.  This is a simple approach to use a Linux container to provide an Open API endpoint to programmatically allow files and links to be scanned.

"The SWS Virus Scan Container project leverages ClamAV docker image and provides a REST API over it, which can be used to scan files and URLs. This container image is compatible with Azure Web apps for Containers and could also be run within other orchestrators like Kubernetes (and AKS)."

GitHub - sws-algorithm-competition/GNU-virus-scan_sws-virus-scan: This is a GNU Virus Scan called sws virus scan made by shaoqirui sws
 

SP2010 install using AutoSPInstaller from PowerGUI

Problem: I want to install SharePoint 2010 using Brian Lala's AutoSPInstaller codeplex project however, I want to be able to see values and debug using PowerShell

Resolution:
Ensure AutoSPInstaller is setup correctly and PowerGUI is installed.  Correct setup is shown below.  Ensure that the xml file is named correctly.

Tip: Windows has a built in graphical debuggger for PowerShell called ISE Editor
http://blogs.msdn.com/b/powershell/archive/2009/01/19/debugging-powershell-script-using-the-ise-editor.aspx

PS> c:\SP2010\AutoSPInstaller\AutoSPInstallerMain.ps1 c:\SP2010\AutoSPInstaller\AutoSPInstallerInput-WIN-2C5PI8TSRPA.xml

Press F5 or the arrow to debug.  I have all the .ps1 files in the PowerGUI editor and add break points. 

Note.  If you hit a break point and press F5 once you are debugging, PowerGUI will not stop at the next break point.  F10 will take you to your next breakpoint or where the next error is trapped.

SP2010 CU April 2011

Overview: Cumulative Update for SharePoint 2010 is the latest CU for SP2010 Server. The CU can be applied to an existing far or added be part of the install using AutoSPInstaller for new installations.

SharePoint Server 2010 cumulative update package  can be found here.  http://support.microsoft.com/default.aspx?scid=kb;EN-US;2512800

Installation:  You need to request the file from the link list above.  Download the file to your local machines (It's about 600MB).
For an update simple extract the from the file 432209_intl_x64_zip.exe using the cmd>432209_intl_x64_zip.exe /extract:.\

 If you want to include the CU in a new install using AutoSPInstaller, you will need to extract the .msp files from office2010-kb2512800-fullfile-x64-glb.exe /extract:.\

And place the msp files inside the approriate directory in you AutoSPInstaller directory.



DCPromo

Migrate Physical dev env to VMWare

Problem:  I have a laptop that boots Windows 2008 R2 and is my based SP2010 dev machine.  I need the machine to be available on a PC will additional memory using virtualisation.

Initial Hypothesis:  I could take an Acronis image of the laptop and then duel boot the the PC but it's far easier to do a P2V (Physical to Virtual) conversion and run the new image using VMWare workstation.

Resolution:
Install VMWare vCenter Converter Standalone client.  Open the VMWare converter application.

 Select "Convert Machine"

 Follow the steps as shown below:

 Finish the wizard and once the task is complete you will see the screen as shown below:

Open VMWare Workstation (V7.1 is the version I used)

Open the virtual disk created by the P2V process and you will now have you VM running inside VMWare (vmdk extension).



SQL Name Pipes Error

Problem: When setting up a development machine, I install SQL before SharePoint.  When I try access SQL Server 2008 R2 using "SQL Server Management Sudio", I get the error "provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server".

Initial Hypothesis: Named pipes are not enabled by default since SQL Server 2000, need to enable Named Pipes usinng "SQL Server Configuration Manager".

Resolution:
All Programs >> Microsoft SQL Server 2008 R2 >> Configuration Tools >> SQL Server Configuration Manager >> Enable both “TCP/IP” and “Named Pipes”.

More Info:
http://blogs.msdn.com/b/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx