Wednesday, March 21, 2012

Mixed mode in the NT Domain World

does anyone have a Microsoft Documented process map of how the security mode
l
works for a SQL Server 7 and/or 2000 in a NT Domain Security?I think this will answer your question.
http://www.microsoft.com/technet/pr...n/sp3sec01.mspx
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Actually, it is not clear as to what I am looking for. We are performing an
IT Audit for SOX.
The sql box is part of a NT Domain. We ran a select statement from the sql
box from sys logins where password is null. It produced a list of Domain ID
s
with null passwords. So the questions is, could I use a domain id from a
non-trusted connection to attach to the database?
Does this make sense?
Thanks
Rob
"Kevin McDonnell [MSFT]" wrote:

> I think this will answer your question.
> [url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sp3sec01.mspx[/ur
l]
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||So the questions is, could I use a domain id from a
non-trusted connection to attach to the database?
Yes. If the same username and password is duplicated on the non-trusted
domain.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment