[BUG]: SqlAzureDacpacDeployment: does not server name when it contains a dot (Azure SQL Managed Instance)

[RKSelvi]

New issue checklist

• I searched for existing GitHub issues
• I read pipeline troubleshooting guide
• I checked how to collect logs

Task name

SqlAzureDacpacDeployment@1

Task version

No response

Issue Description

This DevOps task SqlAzureDacpacDeployment@1 is not taking into consideration for the Azure SQL Managed Instance where the host name contains a alpha numeric in its name. For e.g. host name is
azure-smi-name.1134rt4445556.database.usgovcloudapi.net

Because of this when the server name is parsed, it is only taking azure-smi-name as the SQL server name whereas it is actually azure-smi-name.1134rt4445556

Getting this error as it has split with the first dot in the provided server name.
##[debug]System.Management.Automation.RuntimeException: System.Management.Automation.RuntimeException: No resource found with serverName azure-smi-name, serverType Microsoft.Sql/servers in subscription . Specify the correct serverName/serverType and try again.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-

Environment type (Please select at least one enviroment where you face this issue)

• Self-Hosted
• Microsoft Hosted
• VMSS Pool
• Container

Azure DevOps Server type

Azure DevOps Server (Please specify exact version in the textbox below)

Azure DevOps Server Version (if applicable)

No response

Operation system

Windows Server 2019

Relevant log output

##[debug]System.Management.Automation.RuntimeException: System.Management.Automation.RuntimeException: No resource found with serverName azure-smi-name, serverType Microsoft.Sql/servers in subscription . Specify the correct serverName/serverType and try again.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-
##[error]System.Management.Automation.RuntimeException: No resource found with serverName azure-smi-name, serverType Microsoft.Sql/servers in subscription . Specify the correct serverName/serverType and try again.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-

Full task logs with system.debug enabled

 [REPLACE THIS WITH YOUR INFORMATION] 

Repro steps

- task: SqlAzureDacpacDeployment@1
      inputs:
        azureSubscription: 'DEV'
        AuthenticationType: 'servicePrincipal'
        ServerName: 'azure-smi-name.1134rt4445556.database.usgovcloudapi.net'
        DatabaseName: 'DB'
        deployType: 'DacpacTask'
        DeploymentAction: 'Publish'
        DacpacFile: 'DB.dacpac'