Welcome › Forums › DSC (Desired State Configuration) › How do I install SQL Server with DSC?
-
AuthorPosts
-
May 4, 2016 at 4:07 am #38565
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.
-
May 4, 2016 at 4:41 am #38566
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...}
-
AuthorPosts
The topic ‘How do I install SQL Server with DSC?’ is closed to new replies.