Answered by:
CRM 4.0 setup could not pass Installing Sql Jobs step

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.comMonday, 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