locked
error while installing crm 4.0. Please help me out RRS feed

  • Question

  • Hi all..

    while installing crm4.0 through silent installation, got an error...checked the log and found Check SqlServerValidator  has failed

    Check SqlServerValidator : Failure: Could not connect to the following SQL Server: 'CS044'. Verify that the server is up and running and that you have SQL Server administrative credentials. The .Net Framework Data Providers require Microsoft Data Access Components(MDAC).  Please install Microsoft Data Access Components(MDAC) version 2.6 or later.
    Retrieving the COM class factory for component with CLSID {2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed due to the following error: 800700c1

    I checked and found im am able to connect to the following server. ...using network service account to install crm and its an admin in that server but still getting the same error

    details mentioned in the log..

    05:38:55|  Error| Check SqlServerValidator : Failure: Could not connect to the following SQL Server: 'CS044'. Verify that the server is up and running and that you have SQL Server administrative credentials. The .Net Framework Data Providers require Microsoft Data Access Components(MDAC).  Please install Microsoft Data Access Components(MDAC) version 2.6 or later.
    Retrieving the COM class factory for component with CLSID {2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed due to the following error: 800700c1.
    05:38:55|Verbose| BaseGroup.Validate completed
    05:38:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
    05:38:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:38:55|Verbose| After context key substitutions RunModes
    05:38:55|Verbose| After env var substitutions RunModes
    05:38:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:38:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:38:55|Verbose| After context key substitutions Setup
    05:38:55|Verbose| After env var substitutions Setup
    05:38:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:38:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate Microsoft SQL Server Reporting Services
    05:38:55|Verbose| Calling BaseGroup.Validate
    05:38:55|   Info| Check ReportingUrlValidator: Success
    05:39:15|   Info| Check ExistingRSValidator: Success
    05:39:15|Verbose| BaseGroup.Validate completed
    05:39:15|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
    05:39:15|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:39:15|Verbose| After context key substitutions RunModes
    05:39:15|Verbose| After env var substitutions RunModes
    05:39:15|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:39:15|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:39:15|Verbose| After context key substitutions Setup;AM
    05:39:15|Verbose| After env var substitutions Setup;AM
    05:39:15|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:39:15|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate Active Directory®
    05:39:15|Verbose| Calling BaseGroup.Validate
    05:39:15|   Info| Check DomainUserValidator: Success
    05:39:15|Verbose| BaseGroup.Validate completed
    05:39:15|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
    05:39:15|Verbose| Validation ran.
    05:39:15|Verbose| Validation completed.
    05:39:15|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run
    05:39:15|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll
    05:39:15|   Info| Microsoft Dynamics CRM Server install Failed.
    05:39:15|   Info| Microsoft Dynamics CRM Server Setup did not complete successfully.
    Error.ValidatorFailed
    05:39:15|Verbose| Method entry: Microsoft.Crm.Setup.Server.ServerSetup.Terminate
    05:39:15|   Info| Exit code: -2
    05:39:15|Verbose| Method exit: Microsoft.Crm.Setup.Server.ServerSetup.Terminate
    05:39:15|   Info| === Managed setup logging stopped: 12/3/2009 5:39:15 AM ===
    05:39:15|   Info| === Setup bootstrap logging started 12/3/2009 5:39:15 AM ===
    05:39:15|   Info| Bootstrap version: 4.0.7333.3.
    05:39:15|   Info| User: gspqa.
    05:39:15|   Info| Managed Setup exited with code -2.
    05:39:15|   Info| === Setup bootstrap logging ended 12/3/2009 5:39:15 AM ===


    Please help me out
    Thursday, December 3, 2009 1:56 PM

Answers

  • Are you able to connect to the server and run a SQL Query using the SQL tools - (you might be able to connect via windows to the sql server, but not have the needed protocols set up to connect via SQL)


    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    Friday, December 4, 2009 1:52 AM
    Moderator

All replies

  • Hi all..

    while installing crm4.0 through silent installation, got an error...checked the log and found Check SqlServerValidator  has failed

    Check SqlServerValidator : Failure: Could not connect to the following SQL Server: 'CS044'. Verify that the server is up and running and that you have SQL Server administrative credentials. The .Net Framework Data Providers require Microsoft Data Access Components(MDAC).  Please install Microsoft Data Access Components(MDAC) version 2.6 or later.
    Retrieving the COM class factory for component with CLSID {2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed due to the following error: 800700c1

    I checked and found im am able to connect to the following server. ...using network service account to install crm and its an admin in that server but still getting the same error

    details mentioned in the log..

    05:38:55|  Error| Check SqlServerValidator : Failure: Could not connect to the following SQL Server: 'CS044'. Verify that the server is up and running and that you have SQL Server administrative credentials. The .Net Framework Data Providers require Microsoft Data Access Components(MDAC).  Please install Microsoft Data Access Components(MDAC) version 2.6 or later.
    Retrieving the COM class factory for component with CLSID {2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed due to the following error: 800700c1.
    05:38:55|Verbose| BaseGroup.Validate completed
    05:38:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
    05:38:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:38:55|Verbose| After context key substitutions RunModes
    05:38:55|Verbose| After env var substitutions RunModes
    05:38:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:38:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:38:55|Verbose| After context key substitutions Setup
    05:38:55|Verbose| After env var substitutions Setup
    05:38:55|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:38:55|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate Microsoft SQL Server Reporting Services
    05:38:55|Verbose| Calling BaseGroup.Validate
    05:38:55|   Info| Check ReportingUrlValidator: Success
    05:39:15|   Info| Check ExistingRSValidator: Success
    05:39:15|Verbose| BaseGroup.Validate completed
    05:39:15|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
    05:39:15|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:39:15|Verbose| After context key substitutions RunModes
    05:39:15|Verbose| After env var substitutions RunModes
    05:39:15|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:39:15|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:39:15|Verbose| After context key substitutions Setup;AM
    05:39:15|Verbose| After env var substitutions Setup;AM
    05:39:15|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    05:39:15|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate Active Directory®
    05:39:15|Verbose| Calling BaseGroup.Validate
    05:39:15|   Info| Check DomainUserValidator: Success
    05:39:15|Verbose| BaseGroup.Validate completed
    05:39:15|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
    05:39:15|Verbose| Validation ran.
    05:39:15|Verbose| Validation completed.
    05:39:15|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run
    05:39:15|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll
    05:39:15|   Info| Microsoft Dynamics CRM Server install Failed.
    05:39:15|   Info| Microsoft Dynamics CRM Server Setup did not complete successfully.
    Error.ValidatorFailed
    05:39:15|Verbose| Method entry: Microsoft.Crm.Setup.Server.ServerSetup.Terminate
    05:39:15|   Info| Exit code: -2
    05:39:15|Verbose| Method exit: Microsoft.Crm.Setup.Server.ServerSetup.Terminate
    05:39:15|   Info| === Managed setup logging stopped: 12/3/2009 5:39:15 AM ===
    05:39:15|   Info| === Setup bootstrap logging started 12/3/2009 5:39:15 AM ===
    05:39:15|   Info| Bootstrap version: 4.0.7333.3.
    05:39:15|   Info| User: gspqa.
    05:39:15|   Info| Managed Setup exited with code -2.
    05:39:15|   Info| === Setup bootstrap logging ended 12/3/2009 5:39:15 AM ===


    Please help me out
    Thursday, December 3, 2009 1:54 PM
  • Are you able to connect to the server and run a SQL Query using the SQL tools - (you might be able to connect via windows to the sql server, but not have the needed protocols set up to connect via SQL)


    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    Friday, December 4, 2009 1:52 AM
    Moderator