question

ashok2012 avatar image
ashok2012 asked

how can we grant access/allow particular IP address from SQL Server?

Hi Experts, how can we grant access/allow particular IP address from SQL Server? Sample Server: System Name: ITFIRE.SYSTEMS.NET IP Address: 166.66.25.20 I need to give Grant access for above IP address 166.66.25.20 from SQL Server? How to achieve this? Any help mostly appreciated!!!!!!!!!!!!!
sqlaccessconnection
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
DenisT avatar image
DenisT answered
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
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.