Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    21

    Unanswered: Quick question about security and MS SQL 2000

    OK, we have a couple of MS SQL 2000 servers running in a Win2k AD domain.

    Both machines are using mixed mode security, the issue appears to be this.

    If I go into AD and change a groups name that has been granted access to
    the SQL server, it doesn't seem to pick up on the name change.

    I also can't add the new name to the SQL server, because of a conflict of a
    SID.

    So how do I get the MS SQL server to refresh the names of the native NT
    groups that have been granted access, then have the names changed ??

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I think you need to drop the old name and add the new one. Why are you doing this? Experimenting?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Nov 2003
    Posts
    21
    Its not uncommon to have a native AD Security group renamed to match
    a changed "department" name lets say.

    SQL 2000 doesn't seem to see the name change in AD, where is this info stored in
    the SQL server ?? is there a SP to refresh the cache or this table ?

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I'd say changing a department name should result in a change of an OU, not a group. But that's just me.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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