SET SQL CONNECTION DETAILS

USE THIS FUNCTION TO SET THE DATABASE CONNECTION DETAILS

Set-VPASSQLConnectionDetails [[-SQLServer] <String>] [[-SQLDatabase] <String>] [[-SQLUsername] <String>] [[-SQLPassword] <String>] [[-AAM] <String>] [[-AppID] <String>] [[-Folder] <String>] [[-SafeID] <String>] [[-ObjectName] <String>] [[-AIMServer] <String>] [[-CertificateTP] <String>] [[-PasswordSDKPath] <String>] [[-SkipConfirmation]] [[-NoSSL]] [<CommonParameters>]

-SQLServer <String>
Fully qualified domain name of the server that is hosting the SQL database that VPASModule is exporting data to

Required: false
Position: 1
Default value:
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

-SQLDatabase <String>
Name of the database that VPASModule is exporting data to

Required: false
Position: 2
Default value:
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

-SQLUsername <String>
Username of the SQL account that will be used to connect to the database
Not recommended to hardcode username/password in scripts, use credential providers if possible

Required: false
Position: 3
Default value:
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

-SQLPassword <String>
Password of the SQL account that will be used to connect to the database
Not recommended to hardcode username/password in scripts, use credential providers if possible

Required: false
Position: 4
Default value:
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

-AAM <String>
Select which method will be used to input credentials. HIGHLY recommended to utilize either CCP or CP
Possible values: CCP, CP, NONE

Required: false
Position: 5
Default value:
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

-AppID <String>
Unique ApplicationID (or Application Name) that will be used by the credential provider(s) to retrieve credentials

Required: false
Position: 6
Default value:
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

-Folder <String>
Folder location of the credential object being pulled via

Required: false
Position: 7
Default value:
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

-SafeID <String>
SafeID that is holding the credential object being pulled via Credential Provider (CP) or Central Credential Provider (CCP)

Required: false
Position: 8
Default value:
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

-ObjectName <String>
Unique ObjectName of the credential object being pulled via Credential Provider (CP) or Central Credential Provider (CCP)

Required: false
Position: 9
Default value:
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

-AIMServer <String>
Fully qualified domain name of the AIMServer if Central Credential Provider (CCP) is being utilized

Required: false
Position: 10
Default value:
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

-CertificateTP <String>
Certificate thumbprint that will be passed in the API call if ApplicationID has a certificate restriction

Required: false
Position: 11
Default value:
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

-PasswordSDKPath <String>
File path of where the PasswordSDK is located to make the Credential Provider (CP) call

Required: false
Position: 12
Default value:
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

-SkipConfirmation [<SwitchParameter>]
Remove the confirmation prompt asking to overwrite the connection details if they already exist

Required: false
Position: 13
Default value: False
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

-NoSSL [<SwitchParameter>]
If the environment is not set up for SSL, API calls will be made via HTTP not HTTPS (Not Recommended!)

Required: false
Position: 14
Default value: False
Accept pipeline input: true (ByPropertyName)
Accept wildcard characters: false

<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug
ErrorAction, ErrorVariable, WarningAction, WarningVariable
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216)

$SetSQLConnectionDetails = Set-VPASSQLConnectionDetails -SQLServer {SQLSERVER VALUE} -SQLDatabase {SQLDATABASE VALUE} -SQLUsername {SQLUSERNAME VALUE} -AAM {AAM VALUE} -AppID {APPID VALUE} -Folder {FOLDER VALUE} -SafeID {SAFEID VALUE} -ObjectName {OBJECTNAME VALUE} -AIMServer {AIMSERVER VALUE}

$SetSQLConnectionDetails = Set-VPASSQLConnectionDetails

$true if successful

$false if failed