Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 management studio permissions

Author  Topic 

svicky9
Posting Yak Master

232 Posts

Posted - 2008-02-12 : 08:08:35
I want to deny a few logins access to sql server...I am using windows Authentictation on the Sql Server...So the Server Uses the Windows Login for the Sql Server Access...I dont see any logins i want to disable on the Sql Server

i did following for denying the non-existence logins access

a.Add the Logins to the on the Server
b.Disable the Accounts

It works fine..but i want to know if there is better way of denying the logins to access the SQL SERVER.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-12 : 23:07:14
Looks like users get access via windows group, double check those logins' permission.
Go to Top of Page
   

- Advertisement -