---
title: "PATCH /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}"
method: PATCH
path: "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}"
tags: ["Servers"]
---

# PATCH /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}

`PATCH /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}`

Updates a server.

## Path parameters

- `resourceGroupName` string, required
- `serverName` string, required
- `subscriptionId` string, required

## Query parameters

- `api-version` string, required

## Request body

- ServerUpdate — An update request for an Azure SQL Database server.
  - `properties` ServerProperties — The properties of a server.
    - `administratorLogin` string — Administrator username for the server. Once created it cannot be changed.
    - `administratorLoginPassword` string — The administrator login password (required for server creation).
    - `version` string — The version of the server.
    - `state` string — The state of the server.
    - `fullyQualifiedDomainName` string — The fully qualified domain name of the server.
  - `tags` object — Resource tags.

## Response `200`

Successfully updated the server.

- Server — unresolved $ref

## Other responses

- `202` — Accepted
- `default` — *** Error Responses: *** * 400 NameAlreadyExists - The provided name already exists. * 400 RegionDoesNotSupportVersion - A user attempted to create a server of a specified version in a location where that server version isn't supported. * 400 ServerNotFound - The requested server was not found. * 400 InvalidUsername - Supplied user name contains invalid characters. * 400 InvalidParameterValue - An invalid value was given to a parameter. * 400 InvalidIdentifier - The identifier contains NULL or an invalid unicode character. * 400 TokenTooLong - The provided token is too long. * 400 InvalidLoginName - The provided login name is invalid. * 400 PasswordTooShort - The provided password is too short * 400 PasswordTooLong - The provided password is too long. * 400 PasswordNotComplex - The provided password is not complex enough. * 400 SubscriptionNotFound - The requested subscription was not found. * 400 InvalidLocation - An invalid location was specified. * 400 InvalidServerName - Invalid server name specified. * 400 RegionDoesNotAllowProvisioning - The selected location is not accepting new Windows Azure SQL Database servers. This may change at a later time. * 404 SubscriptionDoesNotHaveServer - The requested server was not found * 404 OperationIdNotFound - The operation with Id does not exist. * 409 OperationCancelled - The operation has been cancelled by user. * 409 OperationInterrupted - The operation on the resource could not be completed because it was interrupted by another operation on the same resource. * 409 ServerAlreadyExists - Duplicate server name. * 409 SubscriptionDisabled - Subscription is disabled. * 409 ServerDisabled - Server is disabled. * 409 ServerQuotaExceeded - Server cannot be added to a subscription because it will exceed quota. * 429 ConflictingSubscriptionOperation - An operation is currently in progress for the subscription. * 429 ConflictingServerOperation - An operation is currently in progress for the server. * 500 OperationTimedOut - The operation timed out and automatically rolled back. Please retry the operation.

---

[API](https://skmtc.dev/azure/apis/sqlmanagementclient-41cb5d25.md) · [All operations](https://skmtc.dev/azure/apis/sqlmanagementclient-41cb5d25/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/azure/sqlmanagementclient-41cb5d25/revisions/51a289ae46cf/schema)