Add firewall rule for azure sql server not working

[polandre90]

Type: Bug

The feature to add a firewall rule when connecting to azure sql server is not working. Add succesfully but then when try to connect i see a message "a unknow error occurred". If a close and open again vs code it works

VS Code version: Code 1.97.2 (e54c774, 2025-02-12T23:20:35.343Z)
OS version: Windows_NT x64 10.0.26100
Modes:

System Info

Item	Value
CPUs	11th Gen Intel(R) Core(TM) i5-1145G7 @ 2.60GHz (8 x 1498)
GPU Status	2d_canvas: enabled canvas_oop_rasterization: enabled_on direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok skia_graphite: disabled_off video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: enabled webnn: disabled_off
Load (avg)	undefined
Memory (System)	15.73GB (1.12GB free)
Process Argv	--crash-reporter-id ea59e606-8d10-4bdf-ba16-61547de6dfa6
Screen Reader	no
VM	0%

Extensions (31)

Extension	Author (truncated)	Version
databricks	dat	2.7.0
sqltools-databricks-driver	dat	0.4.2
copilot	Git	1.275.0
copilot-chat	Git	0.24.1
Ionide-fsharp	Ion	7.25.3
vscode-azure-github-copilot	ms-	0.3.153
vscode-azureresourcegroups	ms-	0.10.6
vscode-cosmosdb	ms-	0.25.0
csdevkit	ms-	1.16.6
csharp	ms-	2.63.32
dotnet-interactive-vscode	ms-	1.0.6110020
vscode-dotnet-pack	ms-	1.0.13
vscode-dotnet-runtime	ms-	2.2.8
data-workspace-vscode	ms-	0.6.0
mssql	ms-	1.29.0
sql-bindings-vscode	ms-	0.4.0
sql-database-projects-vscode	ms-	1.4.6
debugpy	ms-	2025.0.1
isort	ms-	2023.10.1
python	ms-	2025.0.0
vscode-pylance	ms-	2025.2.1
jupyter	ms-	2024.11.0
jupyter-keymap	ms-	1.1.2
jupyter-renderers	ms-	1.1.0
vscode-jupyter-cell-tags	ms-	0.1.9
vscode-jupyter-slideshow	ms-	0.1.6
azurecli	ms-	0.6.0
notepadplusplus-keybindings	ms-	1.0.7
vsliveshare	ms-	1.0.5948
sqltools	mtx	0.28.4
vscode-yaml	red	1.16.0

A/B Experiments

vsliv368cf:30146710
vspor879:30202332
vspor708:30202333
vspor363:30204092
vswsl492:30256859
vscod805:30301674
binariesv615:30325510
py29gd2263:31024239
vscaac:30438847
c4g48928:30535728
azure-dev_surveyone:30548225
a9j8j154:30646983
962ge761:30959799
h48ei257:31000450
pythontbext0:30879054
cppperfnew:31000557
dwnewjupyter:31046869
nativerepl2:31139839
pythonrstrctxt:31112756
nativeloc1:31192215
iacca1:31171482
5fd0e150:31155592
dwcopilot:31170013
6074i472:31201624
dwoutputs:31242946
customenabled:31248079
hdaa2157:31222309
copilot_t_ci:31222730
jda6j935:31233686
copilothoveron:31248524

[gjsjohnmurray]

/causedByExtension

[vs-code-engineering]

This issue is caused by an extension, please file it with the repository (or contact) the extension has linked in its overview in VS Code or the marketplace for VS Code. See also our issue reporting guidelines. If you don't know which extension is causing the problem, you can run Help: Start extension bisect from the command palette (F1) to help identify the problem extension.

Happy Coding!