Share via


Set-SCSPFConnectionString

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.

Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-Confirm

Prompts you for confirmation before running the cmdlet.

Required?

false

Position?

named

Default Value

false

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-WhatIf

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

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 (https://go.microsoft.com/fwlink/p/?LinkID=113216).

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;"

Get-SCSPFConnectionString