[AVM Module Issue]: Private end point creation fails some times in SQL Database module

### Check for previous/existing GitHub issues

- [x] I have checked for previous/existing GitHub issues

### Issue Type?

Bug

### Module Name

avm/res/sql/server

### (Optional) Module Version

0.20.2

### Description

The Private end point deployment fails incosistently with below error:

```json
{
"code": "DeploymentFailed",
"target": "/subscriptions//resourceGroups//providers/Microsoft.Resources/deployments/avm.res.sql.server.sqldb-clientadvisoryfvpg",
"message": "At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-deployment-operations for usage details.",
"details": [
{
"code": "ResourceDeploymentFailure",
"target": "/subscriptions//resourceGroups//providers/Microsoft.Resources/deployments/idjr7xkdbzvfs-server-PrivateEndpoint-0",
"message": "The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.",
"details": [
{
"code": "DeploymentFailed",
"target": "/subscriptions//resourceGroups//providers/Microsoft.Resources/deployments/idjr7xkdbzvfs-server-PrivateEndpoint-0",
"message": "At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-deployment-operations for usage details.",
"details": [
{
"code": "AnotherOperationInProgress",
"message": "Another operation on this or dependent resource is in progress. To retrieve status of the operation use uri: https://management.azure.com/subscriptions//providers/Microsoft.Network/locations//operations/?api-version=2019-02-01.",
"details": []
}
]
}
]
}
]
}
```

### (Optional) Correlation Id

_No response_

Start with the avm/res/sql/server module and reproduce private endpoint creation using the reported deployment error. Inspect the Azure deployment operations for the nested PrivateEndpoint deployment and identify the conflicting operation. Done means private endpoint deployment completes consistently without AnotherOperationInProgress failures.

Written by the indexing model from the issue text.