Set-ClassificationInstanceCredential
Published 25 September 2019
Updates authentication details for a single SQL Server instance.
Syntax
Set-ClassificationInstanceCredential [-FullyQualifiedInstanceName] <string> [-UserId <string>] [-Password <string>] [-DataScanningEnabled <bool>] [<CommonParameters>]
Description
Updates authentication details for a single SQL Server instance, i.e. userId and password for SQL Server authentication.
Parameters
-FullyQualifiedInstanceName
<String>
The fully-qualified name of the SQL Server instance to be registered. For a named instance, this should take the form 'fully-qualified-host-name\instance-name' (e.g. "myserver.mydomain.com\myinstance"). For the default instance on a machine, just the fully-qualified name of the machine will suffice (e.g. "myserver.mydomain.com").
| Aliases | None |
| Required? | true |
| Position? | 1 |
| Default Value | None |
| Accept Pipeline Input | True (ByValue) |
| Accept Wildcard Characters | false |
-UserId
<String>
Used only for SQL Server Authentication. Known also as "user name". Optional, do not provide for Windows Authentication.
| Aliases | None |
| Required? | false |
| Position? | named |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-Password
<String>
Used only for SQL Server Authentication. Optional, do not provide for Windows Authentication.
| Aliases | None |
| Required? | false |
| Position? | named |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-DataScanningEnabled
<Boolean>
Enable data scanning and information type prediction for the instance. Optional, defaults to false.
| Aliases | None |
| Required? | false |
| Position? | named |
| Default Value | False |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-ProgressAction
<ActionPreference>
{{ Fill ProgressAction Description }}
| Aliases | None |
| Required? | false |
| Position? | named |
| Default Value | None |
| 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 http://technet.microsoft.com/en-us/library/hh847884.aspx.
Inputs
The input type is the type of the objects that you can pipe to the cmdlet.
-
None.
You cannot pipe input to this cmdlet.
Examples
-------------------------- EXAMPLE 1 --------------------------
Set-ClassificationInstanceCredential -FullyQualifiedInstanceName 'mysqlserver.mydomain.com\myinstancename'
Sets an authentication method to Windows Authentication for a registered instance of SQL Server named "myinstancename" running on the "mysqlserver.mydomain.com" machine.
-------------------------- EXAMPLE 2 --------------------------
Set-ClassificationInstanceCredential -FullyQualifiedInstanceName 'mysqlserver.mydomain.com\myinstancename' -UserId 'somebody' -Password 'myPassword'
Sets an authentication method to SQL Server Authentication with given userId and password for a registered instance of SQL Server named "myinstancename" running on the "mysqlserver.mydomain.com" machine.
