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