Very Computer

Hi,
I am asking if there is a way to fetch the SAM file into SQL database and
write back?

I just want to centralize the user management.
thanks
bill

Hi, Bill:

I am not sure if I understand your question correct.  Are you looking for a
way to save the
NT users' passwords in SQL server database?

SQL server can only keeps the SQL logins' passwords and they are encrypted.
 When NT users
try to connect to SQL server, it's up to the domain controller to verify if
those NT users passwords are
correct.  

Xiaoyu Li
Microsoft SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure?  For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Thanks Li,
If SQL server can not save the windows user info, can you suggest any other
way I can go around? can exchange server help?

I am working on a project needs to store the whole domain's user names and
passwords(even encrypted) into our center database.

bill

Quote:> Hi, Bill:

> I am not sure if I understand your question correct.  Are you looking for
a
> way to save the
> NT users' passwords in SQL server database?

> SQL server can only keeps the SQL logins' passwords and they are
encrypted.
>  When NT users
> try to connect to SQL server, it's up to the domain controller to verify
if
> those NT users passwords are
> correct.

> Xiaoyu Li
> Microsoft SQL Server Support

> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Are you secure?  For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.

Bill, I don't think NT will give out passwords associated with logins.
--
HTH,
Vyas, MVP (SQL Server)

http://vyaskn.tripod.com/
HAPPY VALENTINES DAY: http://vyaskn.tripod.com/valentines_day_sql_card.htm

Thanks Li,
If SQL server can not save the windows user info, can you suggest any other
way I can go around? can exchange server help?

I am working on a project needs to store the whole domain's user names and
passwords(even encrypted) into our center database.

bill

Quote:> Hi, Bill:

> I am not sure if I understand your question correct.  Are you looking for
a
> way to save the
> NT users' passwords in SQL server database?

> SQL server can only keeps the SQL logins' passwords and they are
encrypted.
>  When NT users
> try to connect to SQL server, it's up to the domain controller to verify
if
> those NT users passwords are
> correct.

> Xiaoyu Li
> Microsoft SQL Server Support

> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Are you secure?  For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.