I have to mention that I am talking about 60 - 100 users. We are having SQL database for specific internal use, where contain all the users in the company. Now we are deploying Windows Active Directory and think of a way to centralize the users. Here is my confusion, since LDAP is a protocol, where should the users be ? On the Active Directory and shared to the SQL via LDAP ? Or on the SQL and shared the way around ? I am totally confused here..
There is no way to share users from LDAP to DB or the other way around. The users can be in LDAP, in DB or in both.
LDAP, beside being a protocol, is a directory: user entries may contain attributes (like givenName, surname, mail ecc) other than uid and password.
You can import attributes from DB to LDAP, but then you need to sync the sources.
Generally speaking it depends on what you need to do.