April 15, 2010 at 5:33 am
I have added windows group to my SQL Server. And I want to deny access to certain members of that windows group who doesn't connected to my SQL Server in the last 90 days. Is it possible to disable individual Windows ID with out adding them separately as Login on my SQL server
April 15, 2010 at 5:49 am
Try issuing a DENY CONNECT SQL to the individual accounts, see if it works.
---------------------------------------------------------------------
April 15, 2010 at 11:24 pm
george,
Its not working. It is expecting Login ID to be present on the SQL Server.
April 15, 2010 at 11:36 pm
You can do any of the following.
1. Add them individually
2. Have them added to a new AD Group, add that group to the server and then deny access.
3. Have those users removed from the AD Group
4. Have the users that do connect added to a different group, grant this new group access and remove the former group.
The better choices (IMO) would be any of the Group options.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply