Add-SCSQLDeployment

Syntax

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

Description

The Add-SCSQLDeployment cmdlet adds a Microsoft SQL Server deployment to a SQL Server profile.

Examples

Example 1: Add a SQL Server deployment to a SQL Server profile

PS C:\> $SQLProfile = Get-SCSQLProfile -Name "SQLProfile01"
PS C:\> $DeploymentRunAsProfile = Get-SCRunAsProfile -Name "NTSystemRAP"
PS C:\> $SARunAsProfile = Get-SCRunAsProfile -Name "SQLAdminRAP"
PS C:\> $SQLSvcsRunAsProfile = Get-SCRunAsProfile -Name "NTSystemRAP"
PS C:\> Add-SCSQLDeployment -SQLProfile $SQLProfile -Name "SQL Deployment 01" -MediaSource "C:\SQLMedia" -InstanceID "SysPrepSQL" -InstanceName "MSSQLSERVER" -DeploymentTimeoutSeconds 3600 -SQLAuthenticationType "SQLServerAuthentication" -EnableNamedPipes $True -EnableTCP $True -SQLSysAdminMemberList @("Contoso\SQLAdmins") -ProductKey $Null -AgentServiceRunAsProfile $SQLSvcsRunAsProfile -SQLServiceRunAsProfile $SQLSvcsRunAsProfile -DeploymentRunAsProfile $DeploymentRunAsProfile -SARunAsProfile $SARunAsProfile

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

The second command gets the RunAsProfile named NTSystemRAP, and then stores that object in the $DeploymentRunAsProfile variable. For more information, type Get-Help Get-SCRunAsProfile. A subsequent command specifies this object to initiate and run the deployment.

The third command gets the RunAsProfile named SQLAdminRAP, and then stores that object in the $SARunAsProfile variable. A subsequent command defines this value as the system administrator credentials for the deployment.

The fourth command gets the RunAsProfile named NTSystemRAP, and then stores that object in the $SQLSvcsRunAsProfile variable. A subsequent command specifies this value as the service account for the SQL Server and SQL Server Agent Windows services,

The final command adds a SQL Server deployment named SQL Deployment 01 to the SQLProfile01 SQL profile. This command specifies RunAsProfile objects that previous commands stored in variables.

Parameters

-AgentServiceRunAsAccount

-DeploymentRunAsAccount

-DeploymentTimeoutSeconds

-EnableNamedPipes

-EnableTCP

-InstanceID

-InstanceName

-JobVariable

-MediaSource

-MergeSQLAnswerFile

-Name

-ProductKey

-PROTipID

-ReportingServiceRunAsAccount

-RunAsynchronously

-SARunAsAccount

-SecurityMode

-SQLConfigurationFile

-SQLProfile

-SQLServiceRunAsAccount

-SQLSysAdminMemberList

Outputs

SQLDeployment

This cmdlet returns a SQLDeployment object.

Related Links

• Get-SCSQLDeployment
• Get-SCSQLProfile
• Remove-SCSQLDeployment
• Set-SCSQLDeployment