How do I install SQL Server with DSC?

[Kiran Participant Points: 0Rank: Member]

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.

[Dave Wyatt Member Points: 0Rank: Member]

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...}

[Author]

Posts