Set-WebSitesConnectionString
Sets a database connection string.
Syntax
Set-WebSitesConnectionString
[-ConnectionString] <String>
[-Type] <DatabaseType>
[-RemoteSettings <RemoteSettings>]
[-SuppressRequestIdLine]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Description
The Set-WebSitesConnectionString cmdlet sets a database connection string for the specified database type. You can set connection strings for either a hosting database or a metering database.
Examples
Example 1: Set a hosting database connection string
PS C:\> Set-WebSitesConnectionString -Type "Hosting" -ConnectionString "Data Source=CN-SERVER01;Initial Catalog=Hosting;User ID=Hosting_HostingAdmin;Password=Password01!"This command modifies the connection string for the hosting database.
Parameters
-Confirm
Prompts you for confirmation before running the cmdlet.
| Type: | SwitchParameter |
| Aliases: | cf |
| Position: | Named |
| Default value: | False |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ConnectionString
Specifies a connection string for a hosting database. Connection strings contain information about a data source and how to connect to it; this information includes such things as the server and database name, and the name and password of the user account making the connection. For example:
-ConnectionString "Server=tcp:contosodb.database.windows.net;Database=Personel;User ID=admin@contoso.com;Password=p@ssw0rd;Trusted_Connection=False;Encrypt=True;"
| Type: | String |
| Position: | 1 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-RemoteSettings
{{Fill RemoteSettings Description}}
| Type: | RemoteSettings |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SuppressRequestIdLine
{{Fill SuppressRequestIdLine Description}}
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Type
Specifies the database type. Valid values are:
- Hosting
- Metering
For example:
-Type "Hosting"
| Type: | DatabaseType |
| Accepted values: | Hosting, Metering |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-WhatIf
Shows what would happen if the cmdlet runs. The cmdlet is not run.
| Type: | SwitchParameter |
| Aliases: | wi |
| Position: | Named |
| Default value: | False |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |