Skip to main content
grammar correction, added link name
Source Link
RLF
  • 14k
  • 2
  • 34
  • 47

If you want to totally restrict certain serverservers, then the Windows Firewall should be configured to the restriction.

See: https://technet.microsoft.com/en-us/library/cc646023(v=sql.110).aspxConfigure the Windows Firewall to Allow SQL Server Access

If you need to prevent a specific login from connecting, then of course you would need to manage that login's rights to the server.

Depending on the granularity of what you need to do, you might need to use both approaches.

If you want to totally restrict certain server, then Windows Firewall should be configured to the restriction.

See: https://technet.microsoft.com/en-us/library/cc646023(v=sql.110).aspx

If you need to prevent a specific login from connecting, then of course you would manage that login's rights to the server.

Depending on the granularity of what you need to do, you might need to use both approaches.

If you want to totally restrict certain servers, then the Windows Firewall should be configured to the restriction.

See: Configure the Windows Firewall to Allow SQL Server Access

If you need to prevent a specific login from connecting, then of course you would need to manage that login's rights to the server.

Depending on the granularity of what you need to do, you might need to use both approaches.

Source Link
RLF
  • 14k
  • 2
  • 34
  • 47

If you want to totally restrict certain server, then Windows Firewall should be configured to the restriction.

See: https://technet.microsoft.com/en-us/library/cc646023(v=sql.110).aspx

If you need to prevent a specific login from connecting, then of course you would manage that login's rights to the server.

Depending on the granularity of what you need to do, you might need to use both approaches.