With SQL Server 2008 Enterprise, can I prevent an Active Directory Account Login ( domain\user ) from connecting if its coming from a host_name?
What I really need to do is this:
On SQL1, login mydomain\user1 is only allowed to login from servers APP2, APP3, and APP4.
If mydomain\user1, though it has a login on SQL1 attempts to connection any other hostname besides APP2, APP3 or APP4 I want to deny it access to SQL1.
Can anyone point me in the right direction for the correct condition(s) for a policy that would work?
Erik A. Grob, MCITP, MCDBA
View Complete Post