Data Management

How Do I: Block Connections to SQL Server by IP Address Using Logon Triggers?

Date Added: Jul 2010
Format: Podcast

This podcast, the speaker tells about how to restrict access to SQL Server 2005 SP 2 (Or Above) based on IP Address. This demo shows how to:- Retrieve the IP Address of the client using the EVENTDATA() function-Use a Logon Trigger to restrict access to a SQL Server instance