Re: Need help with a security issue on MS SQL 2000
From: Derrick Leggett (derrickleggett_at_yahoo.com)
Date: 10/22/04
- Previous message: Arnie Rowland: "Re: What's the hardest 2 or 3 things to do for SQL Srv security?"
- In reply to: Chris: "Need help with a security issue on MS SQL 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 22 Oct 2004 02:16:52 -0500
You script out the permissions, drop the user, edit the script, and recreate
it. The other option (not recommended) is to add the new user, record the
SID, delete the new user, then manually edit the syslogins table. I would
HIGHLY recommend you not do this.
"Chris" <Chris@discussions.microsoft.com> wrote in message
news:C24C1233-3EFF-4990-894A-AC0A34A4EA60@microsoft.com...
> 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 ??
- Previous message: Arnie Rowland: "Re: What's the hardest 2 or 3 things to do for SQL Srv security?"
- In reply to: Chris: "Need help with a security issue on MS SQL 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
