az sql server

Manage SQL servers. Azure CLI reference

21 commands 13 options Its page in the Azure CLI reference

Commands

21, each with its page

ad-adminManage a server's Active Directory administrator.ad-only-authManage Azure Active Directory only Authentication settings for this Server.advanced-threat-protection-settingManage a server's advanced threat protection setting.audit-policyManage a server's auditing policy.conn-policyManage a server's connection policy.createCreate a server.deleted-serverGets details of deleted SQL servers.dns-aliasManage a server's DNS aliases.firewall-ruleManage a server's firewall rules.ipv6-firewall-ruleManage a server's ipv6 firewall rules.keyManage a server's keys.listList available servers.ms-supportManage a server's Microsoft support operations.outbound-firewall-ruleManage a server's outbound firewall rules.refresh-external-governance-statusRefreshes external governance status.restoreRestore a deleted SQL server.showGets a server tde-keyManage a server's encryption protector.updateUpdate a server.vnet-ruleManage a server's virtual network rules.waitPlace the CLI in a waiting state until a condition of the SQL server is met.

Options

13 in the Azure CLI reference

--admin-password, -pThe administrator login password (required forserver creation).

--admin-user, -uAdministrator username for the server.

--assign_identity, -iGenerate and assign an Azure Active Directory Identity for this server for use with key management services like Azure KeyVault.

--enable-public-network, -eSet whether public network access to server is allowed or not.

--federated-client-id, --fidThe federated client id used in cross tenant CMK scenario.

--identity-type, -tType of Identity to be used.

--key-id, -kThe key vault URI for encryption.

--minimal-tls-versionThe minimal TLS version enforced by the sql server for inbound connections.

--name, -nName of the Azure SQL Server.

--primary-user-assigned-identity-id, --pidThe ID of the primary user managed identity.

--restrict-outbound-network-access, -rSet whether outbound network access to server is restricted or not.

--soft-delete-retention-days, --sdrdSpecify the number of days to retain soft deleted server (0-7).

--user-assigned-identity-id, -aGenerate and assign an User Managed Identity(UMI) for this server.