New-CMSqlServerSetting

Creates a SQL Server settings object in Configuration Manager.

Syntax

New-CMSqlServerSetting
   [-Confirm]
   [-CopySqlServerExpressOnSecondarySite]
   [-DisableWildcardHandling]
   [-ForceWildcardHandling]
   [-SqlServerServiceBrokerPort <Int32>]
   [-SqlServerServicePort <Int32>]
   [-WhatIf]
   [<CommonParameters>]
New-CMSqlServerSetting [-Confirm] [-DisableWildcardHandling] [-ForceWildcardHandling] [-InstanceName ]
 -SiteDatabaseName  [-SqlServerServiceBrokerPort ] [-UseExistingSqlServerInstance] [-WhatIf]
 []

Description

The New-CMSqlServerSetting cmdlet creates a Microsoft SQL Server settings object in Microsoft System Center 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.

Examples

Example 1: Create a SQL Server settings object

PS C:\> New-CMSqlServerSetting -CopySqlServerExpressOnSecondarySite -SqlServerServiceBrokerPort 4037

This command creates a SQL Server settings object that specifies that System Center Configuration Manager copies Microsoft SQL Server Express to a secondary site. The command specifies that System Center Configuration Manager use port 4037 for the SQL Server Service Broker.

Required Parameters

-CopySqlServerExpressOnSecondarySite

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

Type:SwitchParameter
Required:True
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-SiteDatabaseName

Specifies a name of the Configuration Manager site database.

Type:String
Required:True
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-UseExistingSqlServerInstance

Indicates that you use the existing instance of SQL Server.

Type:SwitchParameter
Required:True
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Optional Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Required:False
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False
-DisableWildcardHandling

Indicates that wildcard handling is disabled.

Type:SwitchParameter
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ForceWildcardHandling

Indicates that wildcard handling is enabled.

Type:SwitchParameter
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-InstanceName

Specifies the name of an instance of SQL Server.

Type:String
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-SqlServerServiceBrokerPort

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

Type:Int32
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-SqlServerServicePort

Specifies a port number for the SQL Server service port.

Type:Int32
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:SwitchParameter
Aliases:wi
Required:False
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False