none
One or more prerequisites for protecting this data source are missing

    Question

  • I have a 5 server SharePoint 2010 farm. All are running windows 2008 x64.

    I installed the agent on all 5 machines. On one of the WFEs I ran

     

    1. ConfigureSharePoint.exe -EnableSharePointProtection

    I have ensured that the SQL VSS Writer is running on the SQL Server box and the sharepoint wss vss writer is running on all machines in the farm.

     

    In my DPM console when I go into the WFE node where I ran configsharepoint, I see a node for Sharepoint and under it I see a node which contains the name of my database. when I click on the checkbox against it I get an error

     

    One or more prerequisites for protecting this data source are missing.
    Ensure that the following prerequisite software is installed on MyServer1, 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=128883

    ID: 3131

     

    My SQL Server box is running SQL Server 2008 x64.

     

    I also went to this URL http://support.microsoft.com/kb/947470 but didn't find any information which would help me fix the issue.

    Wednesday, October 13, 2010 10:37 AM

Answers

  • I opened a support case with Microsoft.

     

    I found that on my SP WFE there was a registry key missing.

     

    if you go into HKLM/Software/Microsoft/Shared Tools/Web Server Extensions/14.0

     

    Here you should have a string name: Version value: 14.0.0.4762

     

    when I created this string value, it worked like a charm.

    • Marked as answer by MSDN Student Tuesday, October 19, 2010 7:58 AM
    Tuesday, October 19, 2010 5:51 AM

All replies

  • Just to confirm that the DPM agent is installed on your back end SQL servers as well as the web front end servers?

    Can I also ask how the web front ends are connecting to the SQL database servers - are they using the servers name or are they using a DNS alias for database connection? I.e. SQL server name is SQL01 but in DNS it may have an alias of SPSQL01 that resolves to the same IP address.
    If you have an alias you need to have the SQL 2005 client connectivity components (if DPM 2007) installed on one of the WFE servers (configure using the clicnfg.exe tool)

    You also might want to verify that you can choose the SQL databases separately from the SharePoint farm view - to verify that communication with the SQL back end servers via DPM is working. Also be sure NOT to select databases on those back end servers for protection under SQL in another protection group - they are treated as one datasource so can only be selected (automatically) by the SharePoint farm selection or the SQL selection.

    Also verify the account that you used when running the configuresharepoint command is a farm administrator account.

    Tuesday, October 19, 2010 2:22 AM
  • I opened a support case with Microsoft.

     

    I found that on my SP WFE there was a registry key missing.

     

    if you go into HKLM/Software/Microsoft/Shared Tools/Web Server Extensions/14.0

     

    Here you should have a string name: Version value: 14.0.0.4762

     

    when I created this string value, it worked like a charm.

    • Marked as answer by MSDN Student Tuesday, October 19, 2010 7:58 AM
    Tuesday, October 19, 2010 5:51 AM
  • I had the same issue and created the reg key  HKLM/Software/Microsoft/Shared Tools/Web Server Extensions/14.0

    String Name: Version

    The Version Value: 14.0.6117.5002

    You can run PowerShell: (get-spfarm).buildversion

    REF:http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=224

    Thank you MSDN Student

    Wednesday, May 09, 2012 3:41 PM