Post reply

Urgent - Windows AD users how disable the db access?

  • June 3, 2009 at 7:17 am

    #210482

    Hi,

    At this moment, all the users of Windows AD user accounts (assinged under adminstrator groups) able to access all the databases in sql server 2005.

    Now we want to disable the some of user accounts to db access? how can i restrict it? Appreciate your reply asap..

    Thanks

  • June 3, 2009 at 7:23 am

    #1003989

    Remove the Built-In\Administrators from the sysadmin group, but make sure that you have at least one other login with sysadmin permissions before doing this.

    See also http://www.mssqltips.com/tip.asp?tip=1017

    [font="Verdana"]Markus Bohse[/font]

Viewing 2 posts - 1 through 2 (of 2 total)

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