This one always gets me off guard so I’m posting this here for more than anything else to remind me. The issue occurs when you configure your MOSS environment which is normally done after installing MOSS. The issue is that while inserting sample data the wizard throws an error which says “Failed to create sample data”. The reason this occurs is because you’ve not configured MSDTC properly. Here are the steps to resolve the problem picked up from this link.

To resolve this issue, configure the security settings for the Microsoft Distributed Transaction Coordinator (DTC) to use the Allow Remote Clients setting. To do this, follow these steps:

  1. Click Start, point to Administrative Tools, and then click Component Services.
  2. In the left pane of the Component Services snap-in, expand Component Services, and then expand Computers.
  3. Right-click My Computer, and then click Properties.
  4. Click the MSDTC tab, and then click Security Configuration under Transaction Configuration.
  5. Under Security Settings, click to select the Network DTC Access check box, if it is not already selected. Then, click to select the Allow Remote Clients check box
  6. Click OK.
  7. When you receive the message that states that the DTC service will be stopped and restarted, click Yes to confirm that you want to continue.
  8. Click OK when you receive the message that the DTC service was restarted.
  9. Click OK.

 

Once the above steps have been executed, running the wizard inserts sample data without any problem.

Tagged with:
 

9 Responses to SharePoint Installation Failed To Create Sample Data

  1. Addie says:

    Thanks! This worked like a charm!!

  2. Deepak says:

    Addie,

    I’m glad that it helped.

  3. Zeepblok says:

    Did’nt work for me :(

  4. windows2008 says:

    Is Server 2008 different than 2003? Because I can get to MSDTC, but I don’t see any Security Configuration under Transaction Configuration or I don’t have option of Transaction Configuration.

  5. Biggs2 says:

    For Server 2008 you must open my computer
    open DTC
    Right click Local DTC
    Click on the security tab
    then you can change the settings
    However, I tried to re-configure and it still stops at the sample data. Let me know if it works for you

  6. windows2003 says:

    Worked for me!! thanks

  7. prasad says:

    it’s greate,but i am unable to login to my site,I did not give any password,it is asking,What i need to do…………?

    Thanks
    Prasad

  8. ty says:

    This works. On a Windows Server 2008 virtual machine you must fully uninstall MOSS then make the changes in the MSDTC and then reinstall MOSS.

    To get to the DTC on a Server 2008 Machine:
    Admin Tools, Component Services, Expand Component Services, Expand Computers, Expand My Computer, Expand Distributed Transaction Coordinator, Right-Click Local DTC, Select ‘Security’ tab, check ‘Network DTC Access’ box, check ‘Allow Remote Clients’ box, OK, restart OK

    Hope this helps. Worked for me!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>