I have a login I need to deny connect to on a server, but it is "hidden" inside a Windows Security Group instead of directly added to SQL Server security.
I cannot deny connect to the whole group. I need to specifically not allow this specific login to connect to this server. But when I try to run DENY CONNECT SQL TO ThisLogin; it fails because the login doesn't exist on the server.
Any thoughts on how I can get this done?
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.