Trying to block SQL access with an NSG.

Byron Viljoen 1 Reputation point
2020-02-25T20:02:29.697+00:00

Hi there,

I am trying to block my WebServer from accessing a SQL instance hosted on my DBServer.

I have included a topology of my network to possibly make troubleshooting easier.

3514-1.png

I have added an incoming rule to my NSG that is associated with my DBServers network interface

3483-2.png

I have even tried creating an NSG on the DBServer subnet to block all SQL access to the entire subnet on port 1433.

For some reason, i can still access my SQL server through SQL management studio on my webserver.

I can easily block access from the Windows firewall, but thats not really the point.

Really not sure what i am doing wrong?

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,201 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jonel M Rienton 1 Reputation point
    2020-03-02T00:16:14.257+00:00

    If you go to your SQL Server -> Security -> Firewalls and virtual networks, do you have the Allow Azure services and resources to access this server set to On?

    0 comments