Azure SQL Database
An Azure relational database service.
5,115 questions
Please change "-FirewallRuleName" by "-RuleName" as described here.
##[error]A parameter cannot be found that matches parameter name 'FirewallRuleName'.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 76%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Kirti Bansal (US)
51
Reputation points
Hi Team,
Have followed the steps mentioned in below documentation for Azure Sql database deployment using azure devops pipeline.
I am not able to run the "CLASSIC" SetAzureFirewallRule.ps1 (to create and update firewall rules), it is giving error as "##[error]A parameter cannot be found that matches parameter name 'FirewallRuleName'"
Any suggestions on this??
ARM one is working fine, until or unless it doesnot have the update step for firewall?.
Have tried with defining parameter inside the functions and viceversa but it is giving the same error.
Accepted answer
-
Alberto Morillo 32,886 Reputation points MVP2022-04-19T10:43:27.937+00:00 -
Kirti Bansal (US) 51 Reputation points
2022-04-21T04:00:21.793+00:00 Thanks for the information. One more query if we use DACPAC task then it is not required to use SetFirewallRule and RemoveFirewall one as the Azure Pipelines agent can communicate with Azure SQL Database, it is required only with SQL Scripts. Correct?
-
Alberto Morillo 32,886 Reputation points MVP
2022-04-21T04:11:01.78+00:00 If on Azure SQL firewall you set "Allow Azure services and resources to access this server" to Yes then Azure Pipeline should communicate with no issues to Azure SQL.
-
Kirti Bansal (US) 51 Reputation points
2022-04-21T06:08:51.69+00:00 Thanks for the information. I have the run script (https://learn.microsoft.com/en-us/azure/devops/pipelines/targets/azure-sqldb?view=azure-devops&tabs=yaml) --classic ======================================> And in AzureDevopsYML file as
- task: AzurePowerShell@2 displayName: Azure PowerShell script for setting up the firewall inputs: azureSubscription: '$(AzureSubscription)' ===>here the service connection ScriptPath: '$(Build.SourcesDirectory)\scripts\SetAzureFirewallRule.ps1' ScriptArguments: '-ServerName $(ServerName)' azurePowerShellVersion: LatestVersion
But it is giving the error as ##[error]No default subscription has been designated. Use Select-AzureSubscription -Default <subscriptionName> to set the default subscription. Have tried to set the subscription in powershell script but it is getting disconnected "Disconnect-AzureRmAccount -Scope Process -ErrorAction Stop" when it tries to run the function.
Any suggestions on this?
-
Alberto Morillo 32,886 Reputation points MVP
2022-04-22T00:34:32.053+00:00 No idea on this one. Please create a new thread maybe other forum members have an idea of what may be the issue and they may be able to provide you possible solutions.
-
Kirti Bansal (US) 51 Reputation points
2022-04-22T07:17:45.237+00:00 Thanks much @Alberto Morillo .
I am able to resolve as i am selecting a ARM subscription, but New AzureSqlDatabaseServerFirewallRule is a classic cmdlet. So i need to use ARM cmdlet for the SQL DB.
as
New-AzureRmSqlServerFirewallRule
Set-AzureRmSqlServerFirewallRuleIt worked properly.
Reference: https://stackoverflow.com/questions/45987965/vsts-azure-powershell-task-sql-firewall-rules -
Alberto Morillo 32,886 Reputation points MVP
2022-04-22T10:14:42.923+00:00 I am glad to know you were able to make it work. Have a great day!
Sign in to comment -
1 additional answer
Sort by: Most helpful
-
Kirti Bansal (US) 51 Reputation points
2022-04-21T06:13:39.023+00:00 Powershell Script-->
[CmdletBinding(DefaultParameterSetName = 'None')]
param
(
[String] [Parameter(Mandatory = $true)] $ServerName,
[String] $AzureFirewallName = "AzureWebAppFirewall"
)$ErrorActionPreference = 'Stop'
az login --service-principal -u <app-id> -p <appsecret> --tenant <tenant-id>
function New-AzureSQLServerFirewallRule {
$agentIP = (New-Object net.webclient).downloadstring("https://api.ipify.org")
New-AzureSqlDatabaseServerFirewallRule -StartIPAddress $agentIp -EndIPAddress $agentIp -RuleName $AzureFirewallName -ServerName $ServerName
}
function Update-AzureSQLServerFirewallRule{
$agentIP= (New-Object net.webclient).downloadstring("https://api.ipify.org")
Set-AzureSqlDatabaseServerFirewallRule -StartIPAddress $agentIp -EndIPAddress $agentIp -RuleName $AzureFirewallName -ServerName $ServerName
}
If ((Get-AzureSqlDatabaseServerFirewallRule -ServerName $ServerName -RuleName $AzureFirewallName -ErrorAction SilentlyContinue) -eq $null)
{
New-AzureSQLServerFirewallRule
}
else
{
Update-AzureSQLServerFirewallRule
}Note: have removed the resourcegroupname as it is giving the same error as giving for FirewallRuleName