Set-SCSQLDeployment
修改SQL Server部署。
语法
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>]说明
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 部署的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部署实例的 ID。
| 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 提示) 的性能和资源优化提示的 ID。 此参数允许审核 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
指示作业以异步方式运行，以便控件立即返回到命令 shell。
| 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 对象。