Set-SCSQLDeployment
修改SQL Server部署。
Syntax
Set-SCSQLDeployment
[-AgentServiceRunAsAccount <VMMCredential>]
[-SQLServiceRunAsAccount <VMMCredential>]
[-SQLConfigurationFile <Script>]
[-ReportingServiceRunAsAccount <VMMCredential>]
[-DeploymentRunAsAccount <VMMCredential>]
[-DeploymentTimeoutSeconds <Int32>]
[-EnableNamedPipes <Boolean>]
[-SARunAsAccount <VMMCredential>]
[-SecurityMode <String>]
[-EnableTCP <Boolean>]
[-ProductKey <String>]
[-SQLDeployment] <SQLDeployment>
[-Name <String>]
[-InstanceID <String>]
[-MediaSource <String>]
[-SQLSysAdminMemberList <String[]>]
[-InstanceName <String>]
[-MergeSQLAnswerFile <Boolean>]
[-RunAsynchronously]
[-PROTipID <Guid>]
[-JobVariable <String>]
[<CommonParameters>]Description
Set-SCSQLDeployment Cmdlet 會修改 Microsoft SQL Server部署。
範例
範例 1：修改現有的SQL Server部署
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")第一個命令會取得名為 SQLProfile01 的SQL Server設定檔，然後將該物件儲存在$SQLProfile變數中。 此命令使用 Get-SCSQLProfile Cmdlet。
第二個命令會從儲存在 $SQLProfile 中的 SQL 設定檔取得名為 SQL Deployment 的SQL Server部署，然後將該物件儲存在$SQLDeployment變數中。
最後一個命令會修改儲存在 $SQLDeployment 中 SQL 部署的SQL Server系統管理員。
參數
-AgentServiceRunAsAccount
指定SQL Server代理程式服務所使用的執行身分帳戶。
| Type: | VMMCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DeploymentRunAsAccount
指定此 Cmdlet 用來修改SQL Server的執行身分帳戶。
| Type: | VMMCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DeploymentTimeoutSeconds
指定SQL Server部署逾時之前所等候的時間量，以秒為單位。
| Type: | Int32 |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-EnableNamedPipes
指出遠端連線是否使用具名管道。
| Type: | Boolean |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-EnableTCP
指出遠端連線是否使用 TCP/IP。
| Type: | Boolean |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-InstanceID
指定SQL Server部署實例的識別碼。
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-InstanceName
指定SQL Server Analysis Services (SSAS) 資料庫實例的名稱。
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-JobVariable
指定追蹤和儲存作業進度的變數。
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-MediaSource
指定要修改之SQL Server部署的媒體來源。
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-MergeSQLAnswerFile
指出此 Cmdlet 是否合併SQL Server組態檔和客體作業系統設定。 預設值為 $True。 Virtual Machine Manager 系統管理員主控台會使用此參數。 請勿在命令提示字元中指定此參數。
| Type: | Boolean |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Name
指定此 Cmdlet 修改SQL Server部署的名稱。
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ProductKey
指定 VMM 伺服器的產品金鑰。 產品金鑰是識別產品授權的一組 25 位數的數字。
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-PROTipID
指定觸發此動作 (PRO 提示) 效能和資源優化提示的識別碼。 此參數可讓您稽核 PRO 秘訣。
| Type: | Guid |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ReportingServiceRunAsAccount
指定Reporting Services使用的執行身分帳戶。
| Type: | VMMCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-RunAsynchronously
表示作業會以非同步方式執行，讓控制項立即返回命令殼層。
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SARunAsAccount
指定SQL Server系統管理員密碼的執行身分帳戶。
| Type: | VMMCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SecurityMode
指定 SQL Server 的安全性模式。 有效值為：WindowsAuthentication 和 SQLServerAuthentication。
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SQLConfigurationFile
指定此 Cmdlet 修改SQL Server部署的組態檔。
| Type: | Script |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SQLDeployment
指定此 Cmdlet 修改SQL Server部署。
| Type: | SQLDeployment |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-SQLServiceRunAsAccount
指定SQL Server服務所使用的執行身分帳戶。
| Type: | VMMCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SQLSysAdminMemberList
指定SQL Server系統管理員的使用者陣列。
| Type: | String[] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
輸出
SQLDeployment
此 Cmdlet 會傳回 SQLDeployment 物件。