Set-WebSitesConnectionString

Set-WebSitesConnectionString

Sets a database connection string.

Syntax

Parameter Set: Default
Set-WebSitesConnectionString [-Type] {Hosting | Metering} [-ConnectionString] <String> [-PipelineVariable <String> ] [-Confirm] [-WhatIf] [ <CommonParameters>]


 

Detailed Description

The Set-WebSitesConnectionString cmdlet sets a database connection string for the specified database type. Specify a database type by using the Type parameter.

Parameters

-ConnectionString<String>

Specifies a connecting string to a hosting database. If this parameter is not specified, the default instance of the hosting database is used.

 

Aliases

none

Required?

true

Position?

2

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

 

-PipelineVariable<String>

Specifies a variable to be used with the pipeline operator.

 

Aliases

pv

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

 

-Type<DatabaseType>

Specifies the database type. Valid values are:

-- Hosting

-- Metering

The acceptable values for this parameter are:

 

Hosting

 

Metering

 

 

 

Aliases

none

Required?

true

Position?

1

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

none

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

none

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.

Examples

Example 1: Set a hosting database connection string

This command sets the hosting database connection string to "Data Source=CN-SERVER01;Initial Catalog=Hosting;User ID=Hosting_HostingAdmin;Password=Password01!".

PS C:\> Set-WebSitesConnectionString -Type Hosting -ConnectionString "Data Source=CN-SERVER01;Initial Catalog=Hosting;User ID=Hosting_HostingAdmin;Password=Password01!"

 

Related topics

Reset-WebSitesConnectionString