set AD password from a SQL proc?

From: Al Blake (al_at__delete_this_.blakes.net)
Date: 03/29/05

  • Next message: Mike Epprecht \(SQL MVP\): "Re: set AD password from a SQL proc?" 
    Date: Tue, 29 Mar 2005 14:28:18 +1000

    Can anyone come up with a way to set an AD password from within a SQL stored
    proc?
    Why?

    a) we create AD accounts for young kids (age 5 up)
    b) We use a SQL stored proc to give them easy to remember passwords
    c) We store these passwords in our SQL database - cos they are young kids
    and they will forget them ;) - and we need to print them out for teachers
    d) We would like to be able to actually set the AD password for the user
    account from *within* the SQL stored proc that generates the password.

    I know that I can do this from using the ADSI interface in vbscript - but
    how can I call the vbscript from within a SQL proc?

    I would like to do something like:

    SetUserPassword(username='fred',password='simple')

    Any ideas?
    Al Blake, Canberra, Australia

  • Next message: Mike Epprecht \(SQL MVP\): "Re: set AD password from a SQL proc?"