Restrict an SQL Server connection to a specific IP address

by

Sounds like something you’d do using the Windows firewall (you can block the SQL Server port(s), and allow exceptions for certain IP addresses).

You could do this with something like a logon trigger that checked the IP address using sys.dm_exec_connections but I think it’s a much less desirable option than blocking the traffic outright.

Certainly much tougher to do at the database level.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Insert an image in a column of a table that already has 5 columns
  3. How to avoid the “divide by zero” error in SQL?
  4. SET versus SELECT when assigning variables?
  5. Querying data by joining two tables in two database on different servers
  6. sql query to return differences between two tables
  7. Real life example, when to use OUTER / CROSS APPLY in SQL
  8. How to print VARCHAR(MAX) using Print Statement?
  9. Concatenate values based on ID
  10. Splitting delimited values in a SQL column into multiple rows
  11. How to find current transaction level?
  12. EXISTS vs JOIN and use of EXISTS clause
  13. Cumulative Total in MS Sql server [duplicate]
  14. How do I find the data directory for a SQL Server instance?
  15. Efficiently convert rows to columns in sql server
  16. How can I get column names from a table in SQL Server?
  17. How can I select the first day of a month in SQL?
  18. Using a Variable in OPENROWSET Query
  19. Check for file exists or not in sql server?
  20. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  21. How to split string using delimiter char using T-SQL?
  22. UNIX_TIMESTAMP in SQL Server
  23. Add emoji / emoticon to SQL Server table
  24. SQL Server SELECT INTO @variable?
  25. How to subtract 30 days from the current date using SQL Server
  26. Count records for every month in a year
  27. Backup SQL Schema Only?
  28. SQL Server: +(unary) operator on non-numeric Strings
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment