Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2010

    Unanswered: Deleted Win-Auth Login

    Hi all,

    I've worked with mssql 2000, 2005 and 2008 for years.
    nowadays, I found some strange thing in my mssql 2000,
    I just deleted a windows authentication login out of my db-server security logins, which previously it was a sys-admin (let's say it is 'domain\username1').

    but I still can login using the 'domain\username1',
    even I can select or update (or any other sql transaction),
    and when I execute sp_who in my master database,
    it display that the login 'domain\username1' connected via host 'my_computer'..
    quite strange (at least for me)... any idea how this can happen?

    Thanks for your upcoming ideas..

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    It'll be getting permissions via windows groups. Check the existing logins and run this for any groups:
     xp_logininfo 'Domain\Group','MEMBERS'
    Note that windows groups can be within groups so you might either need to keep running this or just go direct to the AD.
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    The user ID (or its domain group) could also belong to the local administrators group, which would allow unlimited access.
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts