Tests/Integration/MSFT_SqlServiceAccount.config.ps1
|
# This is used to make sure the integration test run in the correct order. [Microsoft.DscResourceKit.IntegrationTest(OrderNumber = 2)] param() $ConfigurationData = @{ AllNodes = @( @{ NodeName = 'localhost' ServerName = $env:COMPUTERNAME DefaultInstanceName = 'MSSQLSERVER' NamedInstanceName = 'DSCSQL2016' ServiceTypeDatabaseEngine = 'DatabaseEngine' ServiceTypeSqlServerAgent = 'SqlServerAgent' PSDscAllowPlainTextPassword = $true } ) } <# .SYNOPSIS Changes the SQL Server service account of the default instance to a different account that was initially used during installation. .NOTES This test was intentionally meant to run as SYSTEM. #> Configuration MSFT_SqlServiceAccount_DatabaseEngine_DefaultInstance_Config { param ( [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlServiceSecondaryCredential ) Import-DscResource -ModuleName 'SqlServerDsc' node localhost { SqlServiceAccount Integration_Test { ServerName = $Node.ServerName InstanceName = $Node.DefaultInstanceName ServiceType = $Node.ServiceTypeDatabaseEngine ServiceAccount = $SqlServiceSecondaryCredential RestartService = $true } } } <# .SYNOPSIS Changes the SQL Server Agent service account of the default instance to a different account that was initially used during installation. .NOTES This test is intentionally meant to run using the credentials in $SqlInstallCredential. #> Configuration MSFT_SqlServiceAccount_SqlServerAgent_DefaultInstance_Config { param ( [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlInstallCredential, [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlAgentServiceSecondaryCredential ) Import-DscResource -ModuleName 'SqlServerDsc' node localhost { SqlServiceAccount Integration_Test { ServerName = $Node.ServerName InstanceName = $Node.DefaultInstanceName ServiceType = $Node.ServiceTypeSQLServerAgent ServiceAccount = $SqlAgentServiceSecondaryCredential RestartService = $true PsDscRunAsCredential = $SqlInstallCredential } } } <# .SYNOPSIS Reverts the SQL Server service account of the default instance to the original account that was initially used during installation. .NOTES This test was intentionally meant to run as SYSTEM. #> Configuration MSFT_SqlServiceAccount_DatabaseEngine_DefaultInstance_Restore_Config { param ( [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlServicePrimaryCredential ) Import-DscResource -ModuleName 'SqlServerDsc' node localhost { SqlServiceAccount Integration_Test { ServerName = $Node.ServerName InstanceName = $Node.DefaultInstanceName ServiceType = $Node.ServiceTypeDatabaseEngine ServiceAccount = $SqlServicePrimaryCredential RestartService = $true } } } <# .SYNOPSIS Reverts the SQL Server Agent service account of the default instance to the original account that was initially used during installation. .NOTES This test is intentionally meant to run using the credentials in $SqlInstallCredential. #> Configuration MSFT_SqlServiceAccount_SqlServerAgent_DefaultInstance_Restore_Config { param ( [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlInstallCredential, [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlAgentServicePrimaryCredential ) Import-DscResource -ModuleName 'SqlServerDsc' node localhost { SqlServiceAccount Integration_Test { ServerName = $Node.ServerName InstanceName = $Node.DefaultInstanceName ServiceType = $Node.ServiceTypeSQLServerAgent ServiceAccount = $SqlAgentServicePrimaryCredential RestartService = $true PsDscRunAsCredential = $SqlInstallCredential } } } <# .SYNOPSIS Changes the SQL Server service account of the named instance to a different account that was initially used during installation. .NOTES This test was intentionally meant to run as SYSTEM. #> Configuration MSFT_SqlServiceAccount_DatabaseEngine_NamedInstance_Config { param ( [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlServiceSecondaryCredential ) Import-DscResource -ModuleName 'SqlServerDsc' node localhost { SqlServiceAccount Integration_Test { ServerName = $Node.ServerName InstanceName = $Node.NamedInstanceName ServiceType = $Node.ServiceTypeDatabaseEngine ServiceAccount = $SqlServiceSecondaryCredential RestartService = $true } } } <# .SYNOPSIS Changes the SQL Server Agent service account of the named instance to a different account that was initially used during installation. .NOTES This test is intentionally meant to run using the credentials in $SqlInstallCredential. #> Configuration MSFT_SqlServiceAccount_SqlServerAgent_NamedInstance_Config { param ( [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlInstallCredential, [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlAgentServiceSecondaryCredential ) Import-DscResource -ModuleName 'SqlServerDsc' node localhost { SqlServiceAccount Integration_Test { ServerName = $Node.ServerName InstanceName = $Node.NamedInstanceName ServiceType = $Node.ServiceTypeSQLServerAgent ServiceAccount = $SqlAgentServiceSecondaryCredential RestartService = $true PsDscRunAsCredential = $SqlInstallCredential } } } <# .SYNOPSIS Reverts the SQL Server service account of the named instance to the original account that was initially used during installation. .NOTES This test was intentionally meant to run as SYSTEM. #> Configuration MSFT_SqlServiceAccount_DatabaseEngine_NamedInstance_Restore_Config { param ( [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlServicePrimaryCredential ) Import-DscResource -ModuleName 'SqlServerDsc' node localhost { SqlServiceAccount Integration_Test { ServerName = $Node.ServerName InstanceName = $Node.NamedInstanceName ServiceType = $Node.ServiceTypeDatabaseEngine ServiceAccount = $SqlServicePrimaryCredential RestartService = $true } } } <# .SYNOPSIS Reverts the SQL Server Agent service account of the named instance to the original account that was initially used during installation. .NOTES This test is intentionally meant to run using the credentials in $SqlInstallCredential. #> Configuration MSFT_SqlServiceAccount_SqlServerAgent_NamedInstance_Restore_Config { param ( [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlInstallCredential, [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlAgentServicePrimaryCredential ) Import-DscResource -ModuleName 'SqlServerDsc' node localhost { SqlServiceAccount Integration_Test { ServerName = $Node.ServerName InstanceName = $Node.NamedInstanceName ServiceType = $Node.ServiceTypeSQLServerAgent ServiceAccount = $SqlAgentServicePrimaryCredential RestartService = $true PsDscRunAsCredential = $SqlInstallCredential } } } |