New-RedgateMonitorAzureSqlDatabaseCredential
Published 18 April 2024
Creates a new temporary object that holds information about a Azure SQL Database credentials.
Syntax
New-RedgateMonitorAzureSqlDatabaseCredential [-FullName] <string> [-BaseMonitor] <BaseMonitor> [[-UserName] <string>] [[-Password] <string>] [[-AzureAuthenticationMode] <string>] [<CommonParameters>]
Description
The New-RedgateMonitorAzureSqlDatabaseCredential cmdlet creates a new temporary object that holds information about a Azure SQL Database credentials. The returned object needs to be passed to New-RedgateMonitorAzureSqlDatabase, as it does not add anything to Redgate Monitor on its own.
Parameters
-FullName
<String>
The full address of the Azure SQL Database server to be monitored, e.g. "sample.database.windows.net".
| Aliases | None |
| Required? | true |
| Position? | 1 |
| Default Value | None |
| Accept Pipeline Input | True (ByValue) |
| Accept Wildcard Characters | false |
-BaseMonitor
<BaseMonitor>
The base monitor to add the monitored object to. For more informatiom, see https://documentation.red-gate.com/monitor14/api/powershell-api/powershell-cmdlet-reference/get-redgatemonitorbasemonitor.
| Aliases | None |
| Required? | true |
| Position? | 2 |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-UserName
<String>
Username to connect to Azure SQL Database instance with. For a Microsoft Entra ID Managed Identity, this can also be used to specify the client ID for a user-assigned identity, for which the -ClientId alias can help improve readability.
| Aliases | None |
| Required? | false |
| Position? | 3 |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-Password
<String>
Password to connect to Azure SQL Database instance with.
| Aliases | None |
| Required? | false |
| Position? | 4 |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-AzureAuthenticationMode
<String>
"SqlServerAuthentication", "MicrosoftEntraIdPassword", "MicrosoftEntraIdIntegrated" or "MicrosoftEntraIdManagedIdentity", the authentication mode which is used to connect to an Azure SQL Database. "AzureActiveDirectoryPassword", "AzureActiveDirectoryIntegrated" and "AzureActiveDirectoryManagedIdentity" are supported aliases for the Microsoft Entra ID authentication modes.
| Aliases | None |
| Required? | false |
| Position? | 5 |
| Default Value | SqlServerAuthentication |
| 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 --------------------------
$credentials = New-RedgateMonitorAzureSqlDatabaseCredential -FullName "sample.database.windows.net" -BaseMonitor $BaseMonitor -UserName "sql_username" -Password "sql_pass" -AzureAuthenticationMode SqlServerAuthentication $credentials | New-RedgateMonitorAzureSqlDatabase
-------------------------- EXAMPLE 2 --------------------------
$credentials = New-RedgateMonitorAzureSqlDatabaseCredential -FullName "sample.database.windows.net" -BaseMonitor $BaseMonitor -UserName "ad_username" -Password "ad_password" -AzureAuthenticationMode AzureActiveDirectoryPassword $credentials | New-RedgateMonitorAzureSqlDatabase
