### Apache Airflow version

2.6.3

### What happened

Till version apache-airflow-providers-microsoft-azure no longer==6.2.2 if you do `WasbHook(wasb_conn_id=self.conn_id).get_conn().account_name` you will get the `account_name` But in version `apache-airflow-providers-microsoft-azure==6.2.3` this is not longer working for below connection:

```
- conn_id: wasb_conn_with_access_key
    conn_type: wasb
    host: astrosdk.blob.core.windows.net
    description: null
    extra:
      shared_access_key: $AZURE_WASB_ACCESS_KEY
```
 

### What you think should happen instead

We should get the `account_name` for `apache-airflow-providers-microsoft-azure==6.2.3`.

### How to reproduce

Try installing the version `apache-airflow-providers-microsoft-azure==6.2.3` and try running below code `WasbHook(wasb_conn_id=self.conn_id).get_conn().account_name` 

### Operating System

Mac

### Versions of Apache Airflow Providers

_No response_

### Deployment

Other Docker-based deployment

### Deployment details

_No response_

### Anything else

_No response_

### Are you willing to submit PR?

- [X] Yes I am willing to submit a PR!

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)

"""Return the BlobServiceClient object."""
        conn = self.get_connection(self.conn_id)
        extra = conn.extra_dejson or {}
        client_secret_auth_config = extra.pop("client_secret_auth_config", {})
        connection_string = self._get_field(extra, "connection_string")
        if connection_string:
            
            return BlobServiceClient.from_connection_string(connection_string, **extra)
        account_url = (
            conn.host
            if conn.host and conn.host.startswith("https://")
            else f"https://{conn.login}.blob.core.windows.net/"
        )
        tenant = self._get_field(extra, "tenant_id")
        if tenant:
            
            app_id = conn.login
            app_secret = conn.password
            token_credential = ClientSecretCredential(tenant, app_id, app_secret, **client_secret_auth_config)
            return BlobServiceClient(account_url=account_url, credential=token_credential, **extra)
        if self.public_read: