Re: Synchronize Active Directory with a SQL-Server database



Pictor,

Nope! you cant get password out of AD domain database....may be you might
need to redefine your model...However leave this post open for a while to
see if someone else has a better idea.

rgds
Babu
"Pictor" <Pictor@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AAF81CE6-572D-481E-B26D-F54BF64F58EF@xxxxxxxxxxxxxxxx
Unfortunately the problem is not the access to the SQL-Server database.
The question is not with the authorization; it is a synchronization
problem
with the DB.

The problem is I have a table in the db where I store data about the same
users of the Active Directory.

In that data I need to save, at least, the username and the password of
the
user of the active directory.
Infact, on the login I check if the user exist in the AD too.
But I can enable/disable this check and make the users to login checking
the
username and the password on the database.

So I need the record of the users in the database to have the same
username
and password of the users in the Active Directory.

But if I execute a query to get the userPassword it goes ok; BUT when I
try
to print the password it is empty.

I need to store the password in the table of the database. I can have it
crypted or not, it's not a problem. But at least I need to get it to read
and
compare.

I'm near to the suicide :(


.



Relevant Pages

  • Re: Is_Member problem : Does user belong to custom Group
    ... In active directory: 1 - Created in Active directory a Windows group named ... 'MyDomainName/MyApplReadOnly' as Login Name and the same as User ... We can create a ROLE in the database and add the users. ...
    (microsoft.public.sqlserver.security)
  • Re: Enter user name, enter password, then press enter...
    ... What do you do when the customer asks that the database login in be the same ... username and password to use all of the stuff that she is permitted to use. ... I have implemented this type of security for Access, VB, and Web Based ASP ...
    (microsoft.public.access.forms)
  • RE: Receiving JDBC error when executing program - Login failed for user sa
    ... says we're using 'sa' so I would think that's the username being passed in. ... | I am receiving the following error when attempting to run my database ... I tried to login the 'sa' account ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Dynamic SQL
    ... Don't need to login to the database. ... OF course entering username N00bHax0r') will cause an error. ... // is the Validators good for this ????? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Is_Member problem : Does user belong to custom Group
    ... - Added in Security/Logins the windows Group 'MyDomainName/MyApplReadOnly' referred as type 'Windows Group' with Defaultdatabase 'Master' ... Then configured the database Role Membership of this user by setting db_datareader and db_denydatawriter to true. ... for the current user returns 0 although he is referred in active directory as someone belonging to the the windows group Mydomainname\MyapplReadOnly ... There is a login, there is a user that mapped to the Login ...
    (microsoft.public.sqlserver.security)