December 5, 2025 at 8:24 pm
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.
December 5, 2025 at 11:15 pm
Nevermind. I needed to leave out the SQL keyword.
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.
December 8, 2025 at 1:21 pm
Hey,
Create a login for the user on the server and deny access so they can not connect, even if their group has permission.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply