Hi,
I have a user repository in Active Directory and a user table in SQL Server and both are in sync . But, whenever any change occurs to the user object or a new user added to AD I need to sync that change with Sql server table. how can I map the user in AD to the user existing in a table in SQL server. Does AD associates an ID for the user so that I can map that to my unique ID in user table in SQL server?
i am trying to do a programme which reads this mapping information and sync the data from AD to SQL server. which is the best way to do this?
Please help me in resolving this issue.
thanks in advance