Data Management

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

Free registration required

Executive Summary

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

  • Format: Podcast
  • Size: 0 KB