How do I install SQL Server with DSC?

Tagged: 

This topic contains 1 reply, has 2 voices, and was last updated by Profile photo of Dave Wyatt Dave Wyatt 7 months, 1 week ago.

  • Author
    Posts
  • #38565
    Profile photo of Kiran
    Kiran
    Participant

    I am using this video (https://www.youtube.com/watch?v=bz3D5ciOdgo) to install SQL Server 2014.

    I see this error after I run start-dscconfiguration SqlServerInstall -Wait Verbose:

    "PowerShell provider MSFT_xSqlServerInstall failed to execute Set-TargetResource functionality with error message: SQL Server installation did not succeed. Form more details ...

    The SendConfigurationApply function did not succeed..."

    What do I do with the error above? It happens after several minutes of processing.
    The DSC that I run above (despite the error) installs SQL Server 2014 Configuration Manager and SQL Server 2014 Error and Usage Reporting. The media can install SSMS and SQL Server Profiler too. I want all the features/options that are normally installed. What should I do?

    Must I modify the MSFT_xSqlServerInstall.psm1 file? I am using PowerShell version 4. Some of the examples on the Internet are geared toward PS v.5.

  • #38566
    Profile photo of Dave Wyatt
    Dave Wyatt
    Moderator

    The xSqlServer module has been pretty extensively updated; you should check out the latest version. That particular resource has been renamed to xSqlServerSetup, I believe, and there are lots of new resources in the module that go above and beyond what little bit was in the original:

    ImplementedAs Name                              ModuleName Version Properties
    ------------- ----                              ---------- ------- ----------
    PowerShell    xSQLDatabaseRecoveryModel         xSQLServer 1.5.0.0 {DatabaseName, RecoveryModel, SqlServerInstance, DependsOn...}
    PowerShell    xSQLServerDatabase                xSQLServer 1.5.0.0 {Database, DependsOn, Ensure, PsDscRunAsCredential...}
    PowerShell    xSQLServerDatabaseOwner           xSQLServer 1.5.0.0 {Database, Name, DependsOn, PsDscRunAsCredential...}
    PowerShell    xSQLServerDatabasePermissions     xSQLServer 1.5.0.0 {Database, Name, Permissions, DependsOn...}
    PowerShell    xSQLServerDatabaseRole            xSQLServer 1.5.0.0 {Database, Name, Role, DependsOn...}
    PowerShell    xSQLServerFailoverClusterSetup    xSQLServer 1.5.0.0 {Action, FailoverClusterNetworkName, Features, InstanceName...}
    PowerShell    xSQLServerFirewall                xSQLServer 1.5.0.0 {Features, InstanceName, DependsOn, Ensure...}
    PowerShell    xSQLServerLogin                   xSQLServer 1.5.0.0 {Name, DependsOn, Ensure, LoginCredential...}
    PowerShell    xSQLServerMaxDop                  xSQLServer 1.5.0.0 {DynamicAlloc, DependsOn, Ensure, MaxDop...}
    PowerShell    xSQLServerMemory                  xSQLServer 1.5.0.0 {DynamicAlloc, DependsOn, Ensure, MaxMemory...}
    PowerShell    xSQLServerNetwork                 xSQLServer 1.5.0.0 {InstanceName, ProtocolName, DependsOn, IsEnabled...}
    PowerShell    xSQLServerPowerPlan               xSQLServer 1.5.0.0 {Ensure, DependsOn, PsDscRunAsCredential}
    PowerShell    xSQLServerRSConfig                xSQLServer 1.5.0.0 {InstanceName, RSSQLInstanceName, RSSQLServer, SQLAdminCredential...}
    PowerShell    xSQLServerRSSecureConnectionLevel xSQLServer 1.5.0.0 {InstanceName, SecureConnectionLevel, SQLAdminCredential, DependsOn...}
    PowerShell    xSQLServerSetup                   xSQLServer 1.5.0.0 {InstanceName, SetupCredential, AgtSvcAccount, ASBackupDir...}
    

You must be logged in to reply to this topic.