Set-SCSPFConnectionString

Applies To: System Center 2012 R2 Orchestrator

Set-SCSPFConnectionString

Sets the connection string to the Service Provider Foundation database. Requires running Windows PowerShell as Administrator.

Syntax

Parameter Set: FromConnectionStringConnectionStringParameterSetName
Set-SCSPFConnectionString -ConnectionString <String> [-Confirm] [-WhatIf] [ <CommonParameters>]

Detailed Description

The Set-SCSPFConnectionString cmdlet sets the database connection string to the Service Provider Foundation database that is used by the server running Service Provider Foundation. The database can be on a separate server. This cmdlet requires running Windows PowerShell as Administrator.

Parameters

-ConnectionString<String>

Specifies the database connection string to a Service Provider Foundation database.

-Confirm

Prompts you for confirmation before executing the command.

-WhatIf

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

<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

1: Set the connection string.

This command sets the connection string to the Service Provider Foundation database on a server named serverSFPDB_7.

PS C:\> Set-SCSPFConnectionString –ConnectionString "Data Source=serverSFPDB_7,1433;Database=SCSPFDB;Integrated Security=True;MultipleActiveResultSets=True;"

Related topics

Get-SCSPFConnectionString