Repair-RDMUserSqlLogin
Synopsis
Fix the SQL login of an existing user
Syntax
__AllParameterSets
Repair-RDMUserSqlLogin [-InputObject] <PSUserInfo> [-PassThru] [-ForcePromptAnswer <DialogResult[]>]
[<CommonParameters>]Description
Fix the SQL login of an existing user, applicable to Microsoft Azure SQL or Microsoft SQL Server workspaces. Ensure the user's authentication type aligns with one of the following ServerUserType property values of the PSUserInfo object: SqlServer (2), AzureAD (8), or Okta (10).
Examples
PS C:\> Get-RDMUser -Name 'myUsername' | Repair-RDMUserSqlLoginFix the SQL login of the user named 'myUserName'
Parameters
-ForcePromptAnswer
Switch to use with caution. It will automatically answer prompt asking yes/no, yes/no/cancel, or ok/cancel questions. In case of multiple prompts, multiple values can be passed to this parameter. Here are the accepted values:
Yes: Accept the prompt. Cover the OK and Automatic value.
No: Refuse the yes/no/cancel prompt. "Cancel" is the fallback option if there is no "No" option.
Cancel: Cancel the yes/no/cancel prompt. "No" is the fallback option if there is no "Cancel" option.
-InputObject
User needing SQL login fixing
-PassThru
Return the PSUserInfo object after the SQL login fix
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
Inputs
RemoteDesktopManager.PowerShellModule.PSOutputObject.PSUserInfo
User object obtained from Get-RDMUser
Notes
For more information, type "Get-Help Repair-RDMUserSqlLogin -detailed". For technical information, type "Get-Help Repair-RDMUserSqlLogin -full".
Last updated
Was this helpful?