Set-SCSPFConnectionString

Sets the connection string to the database used by the Service Provider Foundation service.

Syntax

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

Description

The Set-SCSPFConnectionString cmdlet sets the database connection string to the database used by the Service Provider Foundation service. The database used by the Service Provider Foundation and the Service Provider Foundation service do not have to be on the same server.

This cmdlet requires running Windows PowerShell as an administrator.

Examples

Example 1: Set the connection string

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

This command sets the connection string to the database used by the Service Provider Foundation service on a server with the name ContosoServerSFPDB_72.

Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:System.Management.Automation.SwitchParameter
Aliases:cf
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-ConnectionString

Specifies the connection string to the database used by the Service Provider Foundation service.

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

-WhatIf

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

Type:System.Management.Automation.SwitchParameter
Aliases:wi
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

Inputs

None

Outputs

System.Object