Hi Experts, how can we grant access/allow particular IP address from SQL Server?
System Name: ITFIRE.SYSTEMS.NET IP Address: 18.104.22.168
I need to give Grant access for above IP address 22.214.171.124 from SQL Server?
How to achieve this? Any help mostly appreciated!!!!!!!!!!!!!
asked May 14, 2015 at 03:00 PM in Default
You can use LOGON TRIGGER and the EVENTDATA function to achieve this. Please the see here -- http://dba.stackexchange.com/questions/37379/limit-connection-rights-on-sql-server
answered May 14, 2015 at 03:18 PM