locked
CRM 4.0 setup could not pass Installing Sql Jobs step RRS feed

  • Question

  • Hello,

    While I am trying to install CRM 4.0 to a server machine setup could not pass the "Installling Sql Job" step. even I wait for more than 30 minutes, setup couldn't pass this step. But Setup process didn't fail and it didn't log any event or exception to error log. My Log seems as follow;

    12:23:32|   Info| Name = p_GetAllOrgsFromAuthInfo, Description = Get all the user's organizations based on authentication information, Target = All
    12:23:32|   Info| Name = p_GetAllOrgsFromCrmUserId, Description = Get all the user's organizations based on CRM UserId, Target = All
    12:23:32|   Info| Name = p_GetCrmUserId, Description = Get the crm user id based on the authentication information and organization id, Target = All
    12:23:32|   Info| Name = p_GetDefaultOrgFromAuthInfo, Description = Gets the default organization of the user based on the authentication information, Target = All
    12:23:32|   Info| Name = p_GetPrivilegesInRole, Description = gets privileges in a role, Target = All
    12:23:32|   Info| Name = p_GetUsersInRole, Description = gets users in a role, Target = All
    12:23:32|   Info| Name = p_CheckPrivilege, Description = verifies if user has specified privilege, Target = All
    12:23:32|   Info| Name = p_CleanupSiteWideNotifications, Description = Cleanup site-wide notifications, Target = All
    12:23:32|   Info| Executing Sql Scripts ...
    12:23:32|   Info| File = Scripts\Constants.sql, Message = Add required database constants to mimic enumerations, Target = All
    12:23:32|   Info| File = Scripts\Constraints.sql, Message = Add required database constraints, Target = All
    12:23:32|   Info| File = Scripts\SqlGovernor.sql, Message = Add required Sql Governor values, Target = All
    12:23:32|   Info| File = Scripts\Reserved.sql, Message = Add required reserved names for config database, Target = All
    12:23:32|   Info| File = Scripts\SecurityRolesOnPremiseAndSPLA.sql, Message = Add pre-defined security roles, Target = OnPremise, SPLA
    12:23:32|   Info| File = Scripts\PrivilegesOnPremiseAndSPLA.sql, Message = Add pre-defined security privileges, Target = OnPremise, SPLA
    12:23:32|   Info| Installing Sql Jobs ...
    12:23:32|   Info| Name = .HardDelete, Description = Add hard delete job, Target = All
    12:23:33|   Info| Name = .SiteWideCleanup, Description = Add site-wide cleanup job, Target = All
    12:23:33|   Info| Executing IDiffBuilder.Pass1 ...
    12:23:33|   Info| Creating relationships ...
    12:23:33|   Info| Executing IDiffBuilder.Pass2 ...
    12:23:33|   Info| Installing Stored Procedures ...
    12:23:33|   Info| Name = p_GetAllOrgsFromAuthInfo, Description = Get all the user's organizations based on authentication information, Target = All
    12:23:33|   Info| Name = p_GetAllOrgsFromCrmUserId, Description = Get all the user's organizations based on CRM UserId, Target = All
    12:23:33|   Info| Name = p_GetCrmUserId, Description = Get the crm user id based on the authentication information and organization id, Target = All
    12:23:33|   Info| Name = p_GetDefaultOrgFromAuthInfo, Description = Gets the default organization of the user based on the authentication information, Target = All
    12:23:33|   Info| Name = p_GetDisabledPrivileges, Description = Returns disabled privilege Ids for organization, Target = All
    12:23:33|   Info| Name = p_GetDisabledAccessRights, Description = Returns disabled AccessRights for organization, Target = All
    12:23:33|   Info| Name = p_DisableCreateUser, Description = Disables CreateUser feature for organization, Target = All
    12:23:33|   Info| Name = p_SetOrganizationCurrentStorageSize, Description = Set organization current db size. Disables CreateEntity feature if size exceeds max size for organization, Target = All
    12:23:33|   Info| Name = p_GetOrganizationFeaturePurchaseStatus, Description = Determines if an organization has purchased a feature, Target = All
    12:23:33|   Info| Name = p_GetPrivilegesInRole, Description = gets privileges in a role, Target = All
    12:23:33|   Info| Name = p_GetUsersInRole, Description = gets users in a role, Target = All
    12:23:33|   Info| Name = p_CheckPrivilege, Description = verifies if user has specified privilege, Target = All
    12:23:33|   Info| Name = p_CleanupSiteWideNotifications, Description = Cleanup site-wide notifications, Target = All
    12:23:33|   Info| Name = fn_GetTimePart, Description = Get Time and Minutes as float for comparison, Target = All
    12:23:33|   Info| Name = p_UpdateCurrentActiveKey, Description = Updates and returns the current active CrmKey, Target = All
    12:23:33|   Info| Executing Sql Scripts ...
    12:23:33|   Info| File = Scripts\Constants.sql, Message = Add required database constants to mimic enumerations, Target = All
    12:23:33|   Info| File = Scripts\SqlGovernor.sql, Message = Add required Sql Governor values, Target = All
    12:23:33|   Info| File = Scripts\SecurityRolesOnPremiseAndSPLA.sql, Message = Add pre-defined security roles, Target = OnPremise, SPLA
    12:23:33|   Info| File = Scripts\PrivilegesOnPremiseAndSPLA.sql, Message = Add pre-defined security privileges, Target = OnPremise, SPLA
    12:23:33|   Info| File = Upgrade\UpgradeEA2.sql, Message = Upgrade settings, Target = All
    12:23:33|   Info| File = Scripts\Features.sql, Message = Add features., Target = All
    12:23:33|   Info| Installing Sql Jobs ...

    Installation user is both defined on Server and SQL side and have admin privileges.

     

    Do you have any idea?

    Thanks

    Monday, July 26, 2010 10:48 AM

Answers

  • After spending long hours to solve this issue, we saw that it is related with the active directory. network topology of the customer could not find the domain controller.

     

    Then we have added a string key to registry under MSCRM  as "PreferredDc" and set the value with the machine name of the Domain Controller. then start the installation.

    • Marked as answer by YasinUstun Friday, July 30, 2010 8:32 AM
    Friday, July 30, 2010 8:32 AM

All replies

  • Hi,

    A couple items to check:

    --Does your sql server have plenty of free space?

    --Does the user your are installing with have rights in active directory to create ad groups?

    --If you tried the installation before, delete the newly created active directory groups and mscrm_config or org_mscrm databases before trying again.

    --Is your initial database and log file size resonable and not super big? 


    Alex Fagundes - www.PowerObjects.com
    Monday, July 26, 2010 12:30 PM
  • Dear Alex,

    I have checked your items, but I need a reference to how to delete the newly created active directory group. Can you show me an example or describe how to do this. Other things are seems Ok.

    Thanks

    Monday, July 26, 2010 12:42 PM
  • After spending long hours to solve this issue, we saw that it is related with the active directory. network topology of the customer could not find the domain controller.

     

    Then we have added a string key to registry under MSCRM  as "PreferredDc" and set the value with the machine name of the Domain Controller. then start the installation.

    • Marked as answer by YasinUstun Friday, July 30, 2010 8:32 AM
    Friday, July 30, 2010 8:32 AM
  • Hi YasinUstun,

    Thanks for this, your suggestion worked for us.

    We were facing this issue from last 2 days your inputs saved our life.

    Hemant.

    Sunday, April 29, 2012 1:53 AM