Cannot disable NTgroup users using Alter Logins script

Question

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

tom.johnston Newbie Points: 5 More actions · Answer 1

You could try the following SQL to disable the NT group.

ALTER LOGIN [Domain\NT_Group_Name] DISABLE

GO

tom.johnston Newbie Points: 5 More actions · Answer 2

You could try the following SQL to deny the group access to SQL Server.

USE [master]

GO

DENY CONNECT SQL TO [[SUTTER-CHS\SC.IT_Data_Services]

GO

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 3

balbirsinghsodhi (7/16/2008)
Sorry about that.
Thank you Jeffrey.

No problem 🙂

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll