MS CRM installing Sample Data  Microsoft.Crm.Tools.SampleDataWizard.exe

Posted on 2006-10-25
Last Modified: 2013-11-24
Recently created a test MS CRM 3 system using the 30 Days Eval Lic, Win 2003 Domain, 3 Servers, DC , SQL 2000 Ent Sp4 and 2003 CRM all installed no problem.. Some bright spark decided they want to do a presentation using the Adventure Cycles  sample data as on the CD, installed by running Microsoft.Crm.Tools.SampleDataWizard.exe in the sample data directory.  Which run's through afterwards checking log see the following errors..

I'm install as an user with full Admin rights and Sa rights in SQL, (Same user as used to install CRM). I guess the error is related to populating the SQL tables  

Everytime I search MS talk about Version 1.2 Sample, and using a Sample Lic but the code isn't long enough..

Any ideas or pointers..


<description>The user does not hold the necessary privileges.</description>
</error></detail>  -  25/10/2006 15:06:45

Error occurred while creating competitors.  -  25/10/2006 15:06:45

Server was unable to process request.  -  25/10/2006 15:06:45

<description>The user does not hold the necessary privileges.</description>
</error></detail>  -  25/10/2006 15:06:45

Error occurred while creating competitors.  -  25/10/2006 15:06:45

Server was unable to process request.  -  25/10/2006 15:06:45
Question by:WOLFIE2000
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Expert Comment

ID: 17845950
When you run the sample data EXE it should give you the option to either use the default user assignments or to manually assign the users to Active Directory users.  You should select to manually select them and then specify the user that you are logged in as as the Admin user.  You can leave the others blank if you'd like.  This should get the data in and give your user full admin rights to the environment.

Accepted Solution

jeromey earned 500 total points
ID: 17845965
Also, be sure to make a backup of the databases (Metadata and CRM) prior to the import.  This will allow you to easily restore the blank databases over top of your demo populated databases so you don't have to go through the a big ordeal to get back to a clean environment.

Author Comment

ID: 17853113
Well I created the users like 4 like.. all 16 for the purpose of the test, all the users have admin rights on the domain (well it is test domain within VM). still don't work.

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Connect MS Access to Cloud JD Edwards Database 4 507
Notes - my question 12 258
FRM-41076 and FRM-40735 errors 7 1,053
CRM 2011 SSRS Question 12 98
Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question