The following error message is received in DPM when trying to add a SharePoint 2010 Web Front End server to a protection group:
One or more prerequisites for protecting this data source are missing.
Ensure that the following prerequisites software is installed on SPWFE1.domain.local, the
front-end web servers and all of the back-end computers running SQL Server (including all
cluster nodes and mirror partner nodes):
All Front-end Web servers:
Windows Server 2008 x64
All Back-end computers running SQL Server:
Windows Server 2003 Sp1 with Knowledge Base article 940349
- OR -
Windows Server 2008
All Front-end Web Servers:
SharePoint Foundation Server 2010
- OR -
Microsoft Office SharePoint Server (MOSS) 2010
Back-end computers running SQL Server:
SQL Server 2000 SP4
- OR -
SQL Server 2005 SP1
- OR -
SQL Server 2008
Servers hosting a mirrored instance of SQL Server:
SQL Server 2005 SP1
- OR -
SQL Server 2008
To obtain the required updates, go to http://go.microsoft.com/fwlink/?LinkId=12883
ID: 31312
After reviewing the DPMRACurr.log on the SharePoint WFE, the following error is shown:
1204 0A4C 06/10 06:41:30.731 61 nesharepoint4namespace.cpp(188) [00000000004362B0] WARNING Failed: Hr: = [0x80070002] Error trying to query the Sharepoint Version
1204 0A4C 06/10 06:41:30.747 31 vssbaserequestor.cpp(1528) NORMAL DependencyLogicalPath SPSQLSRV1.DOMAIN.LOCAL\SPSQLSRV1 refers to a Component with LogicalPath SPSQLSRV1 on LocalMachine SPSQLSRV1.DOMAIN.LOCAL
1204 0A4C 06/10 06:41:30.747 61 nesharepoint4namespace.cpp(181) [00000000004362B0] WARNING Failed: Hr: = [0x80070002] : Failed: Hr: = [0x80070002] Error trying to query the Version in HLKM\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0
The key point in the error message is Error trying to query the Version in HLKM\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0. Once you check the registry, You'll notice that the REG_SZ Version key is missing.
It seems that by using the SharePoint 2010 Management Shell to pre-create the the Farm Config and Administration Content Databases before running the SharePoint 2010 Products and Configuration Wizard, neglects to create this Version registry key. (Reproduced on two systems). This causes DPM to throw error messages when you attempt to add the WFE to the DPM 2010 Protection Group.
In this case to fix the issue I manually created the Version REG_SZ key in HLKM\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0. Once this is done you can successfully add the SharePoint 2010 WFE to the DPM 2010 Protection Group. I used the second SharePoint 2010 WFE (which was simply added to the farm using the wizard) Registry to obtain the version number which was: 14.0.0.4762
In case your wondering the command to create the databases before running the Configuration Wizard is:
New-SPConfigurationDatabase -DatabaseName SP_Farm_Config -DatabaseServer SQLServer -AdministrationContentDatabaseName SP_Admin_Content
