replicate users between SQL and AD

[bshbsh]

Is there any tool or utility (either free or not) that can accomplish this. I have an application that can login to the SQL database users or into AD, but not both.
I was wondering is there was any tool which would help me either selectively or fully migrate usernames/password from SQL to AD and vice-versa.
Please advice.
Thanks.

 

[mrdenny]

There are AD native tools which will dump the AD database to a csv file, or create accounts from a csv file.

What's the end result that you are trying to get?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[bshbsh]

There are some users who I do not want in my AD. The app will not authenticate to both. So for a project which will have both internal and external users, I point my app to the SQL DB and want to import my internal users from AD to the SQL Database.

The end result I am trying to achieve is that I want to maintain 2 sources of users, one AD and one in SQL DB and be able to migrate user info (mainly userid and password) between the 2 whenever I want to.

 

[mrdenny]

That's not going to be an easy process. The passwords in each are stored via a one way hash. Cracking the passwords is a very time consumming process.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com