This topic has not yet been rated - Rate this topic

New-CMSqlServerSetting

Updated: March 1, 2013

Applies To: System Center 2012 Configuration Manager SP1

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

New-CMSqlServerSetting

Creates a SQL Server settings object in Configuration Manager.

Syntax

PowerShell

Parameter Set: NewSqlServerSettingsbyCopy
New-CMSqlServerSetting -CopySqlServerExpressOnSecondarySite [-SqlServerServiceBrokerPort <Int32> ] [-SqlServerServicePort <Int32> ] [-Confirm] [-WhatIf] [ <CommonParameters>]

Parameter Set: NewSqlServerSettingsbyExisting
New-CMSqlServerSetting -SiteDatabaseName <String> -UseExistingSqlServerInstance [-InstanceName <String> ] [-SqlServerServiceBrokerPort <Int32> ] [-Confirm] [-WhatIf] [ <CommonParameters>]

Detailed Description

The New-CMSqlServerSetting cmdlet creates a Microsoft SQL Server settings object in Microsoft System Center 2012 Configuration Manager. The object specifies settings for the name of the site database and the port number for the SQL Server service and SQL Server Service Broker.

Parameters

-CopySqlServerExpressOnSecondarySite

Specifies that Microsoft SQL Server Express is copied to a secondary site.

Aliases	none
Required?	true
Position?	named
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-InstanceName<String>

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-SiteDatabaseName<String>

Specifies a name of the Configuration Manager site database.

Aliases	none
Required?	true
Position?	named
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-SqlServerServiceBrokerPort<Int32>

Specifies a port number for the SQL Server Service Broker port.

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-SqlServerServicePort<Int32>

Specifies a port number for the SQL Server service port.

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-UseExistingSqlServerInstance

Aliases	none
Required?	true
Position?	named
Default Value	none
Accept Pipeline Input?	True (ByPropertyName)
Accept Wildcard Characters?	false

-Confirm

Prompts you for confirmation before executing the command.

Required?	false
Position?	named
Default Value	false
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

-WhatIf

Describes what would happen if you executed the command without actually executing the command.

Required?	false
Position?	named
Default Value	false
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters.

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

Outputs

The output type is the type of the objects that the cmdlet emits.

Examples

Example 1:

PowerShell

PS C:\>

PowerShell

PS C:\>

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)