The xSQLServer module contains DSC resources for deployment and configuration of SQL Server in a way that is fully compliant with the requirements of System Center.
Please check out common DSC Resources contributing guidelines.
- xSQLServerSetup installs a standalone SQL Server instance
- xSQLServerFirewall configures firewall settings to allow remote access to a SQL Server instance.
- xSQLServerRSSecureConnectionLevel sets the secure connection level for SQL Server Reporting Services.
- xSQLServerFailoverClusterSetup installs SQL Server failover cluster instances.
- xSQLServerRSConfig configures SQL Server Reporting Services to use a database engine in another instance.
- xSQLServerLogin resource to manage SQL logins
- xSQLServerDatabaseRole resource to manage SQL database roles
- xSQLServerDatabasePermissions resource to manage SQL database permissions
- xSQLServerDatabaseOwner resource to manage SQL database owners
- xSQLDatabaseRecoveryModel resource to manage database recovery model
- xSQLServerMaxDop resource to manage MaxDegree of Parallism for SQL Server
- xSQLServerMemory resource to manage Memory for SQL Server
- xSQLServerPowerPlan resource to manage windows powerplan on SQL Server
- SourcePath: (Required) UNC path to the root of the source files for installation.
- SourceFolder: Folder within the source path containing the source files for installation.
- SetupCredential: (Required) Credential to be used to perform the installation.
- SourceCredential: Credential used to access SourcePath
- SuppressReboot: Supresses reboot
- ForceReboot: Forces Reboot
- Features: (Key) SQL features to be installed.
- InstanceName: (Key) SQL instance to be installed.
- InstanceID: SQL instance ID, if different from InstanceName.
- PID: Product key for licensed installations.
- UpdateEnabled: Enabled updates during installation.
- UpdateSource: Source of updates to be applied during installation.
- SQMReporting: Enable customer experience reporting.
- ErrorReporting: Enable error reporting.
- InstallSharedDir: Installation path for shared SQL files.
- InstallSharedWOWDir: Installation path for x86 shared SQL files.
- InstanceDir: Installation path for SQL instance files.
- SQLSvcAccount: Service account for the SQL service.
- SQLSvcAccountUsername: Output user name for the SQL service.
- AgtSvcAccount: Service account for the SQL Agent service.
- AgtSvcAccountUsername: Output user name for the SQL Agent service.
- SQLCollation: Collation for SQL.
- SQLSysAdminAccounts: Array of accounts to be made SQL administrators.
- SecurityMode: SQL security mode.
- SAPwd: SA password, if SecurityMode=SQL.
- InstallSQLDataDir: Root path for SQL database files.
- SQLUserDBDir: Path for SQL database files.
- SQLUserDBLogDir: Path for SQL log files.
- SQLTempDBDir: Path for SQL TempDB files.
- SQLTempDBLogDir: Path for SQL TempDB log files.
- SQLBackupDir: Path for SQL backup files.
- FTSvcAccount: Service account for the Full Text service.
- FTSvcAccountUsername: Output username for the Full Text service.
- RSSvcAccount: Service account for Reporting Services service.
- RSSvcAccountUsername: Output username for the Reporting Services service.
- ASSvcAccount: Service account for Analysus Services service.
- ASSvcAccountUsername: Output username for the Analysis Services service.
- ASCollation: Collation for Analysis Services.
- ASSysAdminAccounts: Array of accounts to be made Analysis Services admins.
- ASDataDir: Path for Analysis Services data files.
- ASLogDir: Path for Analysis Services log files.
- ASBackupDir: Path for Analysis Services backup files.
- ASTempDir: Path for Analysis Services temp files.
- ASConfigDir: Path for Analysis Services config.
- ISSvcAccount: Service account for Integration Services service.
- ISSvcAccountUsername: Output user name for the Integration Services service.
- Ensure: (Key) Ensures that SQL firewall rules are Present or Absent on the machine.
- SourcePath: (Required) UNC path to the root of the source files for installation.
- SourceFolder: Folder within the source path containing the source files for installation.
- Features: (Key) SQL features to enable firewall rules for.
- InstanceName: (Key) SQL instance to enable firewall rules for.
- DatabaseEngineFirewall: Is the firewall rule for the Database Engine enabled?
- BrowserFirewall: Is the firewall rule for the Browser enabled?
- ReportingServicesFirewall: Is the firewall rule for Reporting Services enabled?
- AnalysisServicesFirewall: Is the firewall rule for Analysis Services enabled?
- IntegrationServicesFirewall: Is the firewall rule for the Integration Services enabled?
- InstanceName: (Key) SQL instance to set secure connection level for.
- SecureConnectionLevel: (Key) SQL Server Reporting Service secure connection level.
- Credential: (Required) Credential with administrative permissions to the SQL instance.
- Action: (Key) { Prepare | Complete }
- SourcePath: (Required) UNC path to the root of the source files for installation.
- SourceFolder: Folder within the source path containing the source files for installation.
- SetupCredential: (Required) Credential to be used to perform the installation.
- SourceCredential: Credential to be used to access SourcePath
- SuppressReboot: Supresses reboot
- ForceReboot: Forces Reboot
- Features: (Required) SQL features to be installed.
- InstanceName: (Key) SQL instance to be installed.
- InstanceID: SQL instance ID, if different from InstanceName.
- PID: Product key for licensed installations.
- UpdateEnabled: Enabled updates during installation.
- UpdateSource: Source of updates to be applied during installation.
- SQMReporting: Enable customer experience reporting.
- ErrorReporting: Enable error reporting.
- FailoverClusterGroup: Name of the resource group to be used for the SQL Server failover cluster.
- FailoverClusterNetworkName: (Required) Network name for the SQL Server failover cluster.
- FailoverClusterIPAddress: IPv4 address for the SQL Server failover cluster.
- InstallSharedDir: Installation path for shared SQL files.
- InstallSharedWOWDir: Installation path for x86 shared SQL files.
- InstanceDir: Installation path for SQL instance files.
- SQLSvcAccount: Service account for the SQL service.
- SQLSvcAccountUsername: Output user name for the SQL service.
- AgtSvcAccount: Service account for the SQL Agent service.
- AgtSvcAccountUsername: Output user name for the SQL Agent service.
- SQLCollation: Collation for SQL.
- SQLSysAdminAccounts: Array of accounts to be made SQL administrators.
- SecurityMode: SQL security mode.
- SAPwd: SA password, if SecurityMode=SQL.
- InstallSQLDataDir: Root path for SQL database files.
- SQLUserDBDir: Path for SQL database files.
- SQLUserDBLogDir: Path for SQL log files.
- SQLTempDBDir: Path for SQL TempDB files.
- SQLTempDBLogDir: Path for SQL TempDB log files.
- SQLBackupDir: Path for SQL backup files.
- ASSvcAccount: Service account for Analysis Services service.
- ASSvcAccountUsername: Output user name for the Analysis Services service.
- ASCollation: Collation for Analysis Services.
- ASSysAdminAccounts: Array of accounts to be made Analysis Services admins.
- ASDataDir: Path for Analysis Services data files.
- ASLogDir: Path for Analysis Services log files.
- ASBackupDir: Path for Analysis Services backup files.
- ASTempDir: Path for Analysis Services temp files.
- ASConfigDir: Path for Analysis Services config.
- ISSvcAccount: Service account for Integration Services service.
- ISSvcAccountUsername: Output user name for the Integration Services service.
- ISFileSystemFolder: File system folder for Integration Services.
- InstanceName: (Key) Name of the SQL Server Reporting Services instance to be configured.
- RSSQLServer: (Required) Name of the SQL Server to host the Reporting Service database.
- RSSQLInstanceName: (Required) Name of the SQL Server instance to host the Reporting Service database.
- SQLAdminCredential: (Required) Credential to be used to perform the configuration.
- IsInitialized: Output is the Reporting Services instance initialized.
- Name: (Key) Name of the SQL Login to create
- LoginCredential: PowerShell Credential for the SQL Login to be created
- LoginType: Type of SQL login to create.(SQL, WindowsUser, WindowsGroup)
- SQLServer: SQL Server where login should be created
- SQLInstance: SQL Instance for the login
- Name: (Key) Name of the SQL Login or the role on the database
- SQLServer: The SQL Server for the database
- SQLInstanceName: The SQL Instance for the database
- Database: The SQL Database for the role
- Role: The SQL role for the database
###xSQLServerDatabasePermissions
- Database: (Key) The SQL Database
- Name: (Required) The name of permissions for the SQL database
- Permissions: (Required) The set of Permissions for the SQL database
- SQLServer: The SQL Server for the database
- SQLInstanceName: The SQL instance for the database
###xSQLServerDatabaseOwner
- Database: (Key) The SQL Database
- Name: (Required) The name of the SQL login for the owner
- SQLServer: The SQL Server for the database
- SQLInstance: The SQL instance for the database
###xSQLDatabaseRecoveryModel
- DatabaseName: (key) The SQL database name
- SQLServerInstance: (Required) The SQL server and instance
- RecoveryModel: (Required) Recovery Model (Full, Simple, BulkLogged)
###xSQLServerMaxDop
- Ensure: (key) An enumerated value that describes if Min and Max memory is configured
- DyamicAlloc: (key) Flag to indicate if MaxDop is dynamically configured
- MaxDop: Numeric value to configure MaxDop to
- SQLServer: The SQL Server for the database
- SQLInstance: The SQL instance for the database
###xSQLServerMemory
- Ensure: (key) An enumerated value that describes if Min and Max memory is configured
- DyamicAlloc: (key) Flag to indicate if Memory is dynamically configured
- MinMemory: Minimum memory value to set SQL Server memory to
- MaxMemory: Maximum memory value to set SQL Server memory to
- SQLServer: The SQL Server for the database
- SQLInstance: The SQL instance for the database
###xSQLServerPowerPlan
- Ensure: (key) An enumerated value that describes if Min and Max memory is configured
<<<<<<< HEAD
- xSQLServerSetup
- Change SourceFolder to Source to allow for multiversion Support
- Add Source Credential for accessing source files
- Add Paramaters for SQL Server configuration
- Add Paramaters to SuppressReboot or ForceReboot
- xSQLServerRSSecureConnectionLevel
- Additional of SQLHelper Function and error handling
- xSQLServerRSConfig
- Additional of SQLHelper Function and error handling
- xSQLServerFirewall
- Additional of SQLHelper Function and error handling
- Change SourceFolder to Source to allow for multiversion Support
- xSQLServerFailoverClusterSetup
- Additional of SQLHelper Function and error handling
- Change SourceFolder to Source to allow for multiversion Support
- Add Paramaters to SuppressReboot or ForceReboot
- Resources Added
- xSQLDatabaseReoveryModeAdded
- xSQLServerDatabaseOwner
- xSQLServerDatabasePermissions
- xSQLServerDatabaseRole
- xSQLServerLogin
- xSQLServerMaxDop
- xSQLServerMemory
- xSQLServerPowerPlan =======
- xSQLServerSetup:
- Corrected bug in GetFirstItemPropertyValue to correctly handle registry keys with only one value.
cd039bfd72f5a433a527cef05634382050a4e356
- xSqlServerSetup:
- Make Features case-insensitive.
- Increased timeout for setup process to start to 60 seconds.
- Updated release with the following new resources
- xSQLServerFailoverClusterSetup
- xSQLServerRSConfig
- Initial release with the following resources
- xSQLServerSetup
- xSQLServerFirewall
- xSQLServerRSSecureConnectionLevel
Examples for use of this resource can be found with the System Center resources, such as xSCVMM, xSCSMA, and xSCOM.