Unable to authenticate to Azure SQL Server via service principal

[ssulei7]

Hi,

Not sure if this is the correct issue template to use, but I am currently working with a customer to build out workflows to deploy DACPACs into their Azure SQL instance. We have created a service principal, but we keep bumping into the following error:

Failed to add firewall rule. Unable to detect client IP address.

Currently, our action is configured as follows:

      - name: Azure SQL Deploy
        uses: Azure/[email protected]
        with:
          connection-string: 'Server=${{ env.serverName}};User ID=***;Password=***;Initial Catalog=${{ env.catalog_name }} ;Authentication=ActiveDirectoryServicePrincipal;'
          dacpac-package: MyDacpac.dacpac
          arguments: '/p:IncludeCompositeObjects=true' 

Are service principals currently not supported by this task?

[huffmajd-LN]

I'm having this issue as well trying to run sql scripts:
"Error: Failed to add firewall rule. Unable to detect client IP Address. Error: There was an error when attempting to execute the process 'sqlcmd'. This may indicate the process failed to start. Error: spawn sqlcmd ENOENT"
I am using SQL authentication.

[dzsquared]

@huffmajd-LN, this issue is describing an enhancement using service principals. if you're running into an error we'd like to help you out - can you open another item with your info?

[github-actions]

This issue is idle because it has been open for 14 days with no activity.

[zijchen]

Support for this is added in v2