security - IP Filtering in sql server 2008 -
i want filter ips in sql server. read on blog suggested using trigger. how can this? don't use firewall or isc or other things.
- logon trigger
- extract ip address client_net_address in sys.dm_exec_connections
- reject connections in trigger based in ip address
i haven't done myself, should straightforward do
Comments
Post a Comment