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

This video shows 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

Read more: http://technet.microsoft.com/en-us/dd898898.aspx

Add this page to your favorite website

Comments

Add New Search

Anonymous |12/01/2012 05:37:12 :oops: b kgkidzfuiuhydu567 Reply | Quote

Write comment
Name:
Email:	do not notifynotify
Website:
Title:
UBBCode:	-color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge
	Please input the anti-spam code that you can read in the image.

!joomlacomment 4.0 Copyright (C) 2009 Compojoom.com . All rights reserved."