Set-SCSQLDeployment

Set-SCSQLDeployment

Modifies a SQL Server deployment.

構文

Parameter Set: Default
Set-SCSQLDeployment [-SQLDeployment] <SQLDeployment> [-AgentServiceRunAsAccount <VMMCredential> ] [-DeploymentRunAsAccount <VMMCredential> ] [-DeploymentTimeoutSeconds <Int32> ] [-EnableNamedPipes <Boolean> ] [-EnableTCP <Boolean> ] [-InstanceID <String> ] [-InstanceName <String> ] [-JobVariable <String> ] [-MediaSource <String> ] [-MergeSQLAnswerFile <Boolean> ] [-Name <String> ] [-ProductKey <String> ] [-PROTipID <Guid]> ] [-ReportingServiceRunAsAccount <VMMCredential> ] [-RunAsynchronously] [-SARunAsAccount <VMMCredential> ] [-SecurityMode <String> ] [-SQLConfigurationFile <Script> ] [-SQLServiceRunAsAccount <VMMCredential> ] [-SQLSysAdminMemberList <String[]> ] [ <CommonParameters>]

詳細説明

The Set-SCSQLDeployment cmdlet modifies a SQL Server deployment.

パラメーター

-AgentServiceRunAsAccount<VMMCredential>

Specifies the Run As account to use for the SQL Server agent service.

-DeploymentRunAsAccount<VMMCredential>

Specifies the Run As account to use for installing SQL Server.

-DeploymentTimeoutSeconds<Int32>

Specifies the amount of time, in seconds, that the SQL Server deployment waits before timing out.

-EnableNamedPipes<Boolean>

Indicates that named pipes are used for remote connections.

-EnableTCP<Boolean>

Indicates that TCP/IP is used for remote connections.

-InstanceID<String>

Specifies a SQL Server deployment instance ID.

-InstanceName<String>

Specifies the SQL Server Analysis Services (SSAS) database instance name.

-JobVariable<String>

Specifies that job progress is tracked and stored in the variable named by this parameter.

-MediaSource<String>

Specifies a media source for a SQL Server deployment.

-MergeSQLAnswerFile<Boolean>

Specifies that the cmdlet merge the specified SQL Server configuration file with the specified guest operating system settings. The default value is $True. This parameter is used by the VMM console. You do not need to use this parameter at the command prompt.

-Name<String>

Specifies the name of a VMM object.

-ProductKey<String>

Specifies a product key. The product key is a 25-digit number that identifies the product license. A product key can be used to register VMM or an operating system to be installed on a virtual machine or host.

-PROTipID<Guid]>

Specifies the ID of the PRO tip that triggered this action. This allows for auditing of PRO tips.

-ReportingServiceRunAsAccount<VMMCredential>

Specifies the Run As account to use for Reporting Services.

-RunAsynchronously

Indicates that the job runs asynchronously so that control returns to the command shell immediately.

-SARunAsAccount<VMMCredential>

Specifies the Run As account to use for the SQL Server system administrator (SA) password.

-SecurityMode<String>

Specifies the security mode for SQL Server. Valid values are:

-- WindowsAuthentication
-- SQLServerAuthentication

-SQLConfigurationFile<Script>

Specifies a SQL Server configuration file.

-SQLDeployment<SQLDeployment>

Specifies a SQL Server deployment object.

-SQLServiceRunAsAccount<VMMCredential>

Specifies the Run As account to use for the SQL Server service.

-SQLSysAdminMemberList<String[]>

Specifies a list of users that are SQL Server administrators.

<CommonParameters>

このコマンドレットは次の共通パラメーターをサポートします。-Verbose、-Debug、-ErrorAction、-ErrorVariable、-OutBuffer、-OutVariable.詳細については、以下を参照してください。 about_CommonParameters (https://go.microsoft.com/fwlink/p/?LinkID=113216)。

入力

入力型は、コマンドレットにパイプできるオブジェクトの型です。

出力

出力型は、コマンドレットによって生成されるオブジェクトの型です。

• SQLDeployment

例

Example Example 1: Modify an existing SQL Server deployment.

The first command gets the SQL Server profile object named SQLProfile01, and then stores the object in the $SQLProfile variable.

The second command gets the SQL Server deployment object named SQL Deployment from the SQL profile stored in $SQLProfile, and then stores the object in the $SQLDeployment variable.

The last command modifies the SQL Server administrators list of the SQL deployment stored in $SQLDeployment.

PS C:\> $SQLProfile = Get-SCSQLProfile -Name "SQLProfile01"
PS C:\> $SQLDeployment = Get-SCSQLDeployment -SQLProfile $SQLProfile -Name "SQL Deployment 01"
PS C:\> Set-SCSQLDeployment -SQLDeployment $SQLDeployment -SQLSysAdminMemberList @("Contoso\SQLAdmins","Contoso\User")

関連トピック

Add-SCSQLDeployment

Get-SCSQLDeployment

Remove-SCSQLDeployment

Get-SCSQLProfile