Again I would simply argue that the application most likely wouldn't know what to do with integrated authentication if it walked up and bit the application on the butt. Depending also on the application, it may make zero sense to use integrated authentication against SQL since the SQL stuff could be accessed by an application ID and the passwords are simply to auth the users walking in the door.
It is very difficult to determine what core backend pieces to change to get functionality without knowing a good bit about how the front end works. My original response still stands though, the mechanism to do this if there even is one depends on the formatting of the passwords going into the DB and/or if you have the ability to intercept the password as it is being changed. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Medeiros, Jose Sent: Wednesday, June 15, 2005 8:04 PM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] Passwords from SQL Hi Rick , Actually how is this off the point? He is looking for a solution that will allow him to use the same user accounts in AD and authenticate against MYSQL, right? He wants to save the time and labor of having to manually update user accounts and passwords since they are maintained by two separate systems and since there are no built in utilities in AD that allow him to easily do so with an Open Source Database such as MYSQL. I strongly believe that by changing to a Microsoft SQL database this allows him to then use integrated authentication and it would solve his problem ( He may not have been aware that Microsoft SQL has had this feature since as far back as version 6.5 ). If the school can't even afford 2000.00 for an SQL database, I seriously doubt that they would have an 8 way server that would easily cost 20,000 or more. But enough said, as far as I am concerned he has two choices and routes he can take and it is up to him to educate his management at the school district office that he has such a need and that the solution has a small cost. I am sure that any educator with common sense would concur that just because some thing is free it does not always mean it is the best solution and easiest to maintain for every environment. Warmest regards, Jose Medeiros Former CIS instructor San Jose City College ---------------------------------------------------------------------------- ----------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rick Kingslan Sent: Wednesday, June 15, 2005 4:37 PM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] Passwords from SQL Maybe they need an 8-way, or more than 2GB of RAM for the database that runs on it. Honestly, though - this has gotten way off the point. He's running MySQL, and doesn't look like he's going to change just because we thought MSSQL is a better fit. Or not.... Rick -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Medeiros, Jose Sent: Wednesday, June 15, 2005 4:07 PM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] Passwords from SQL Why do you need the Enterprise version, are you running SQL Cluster's for failover? Jose -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jacob Stabl Sent: Wednesday, June 15, 2005 12:25 PM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] Passwords from SQL Well we purchased the enterprise MSSQL version. Also we have already purchased exchange here -- Jake -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Medeiros, Jose Sent: Wednesday, June 15, 2005 3:13 PM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] Passwords from SQL Hi Jake, I know that Exchange is dirt cheap for Educational use, I am sure that SQL is also much less. Let me check with an educational speacilist at Microsoft in San Francisco and see what it actually may be. Just doing a serach on the web for the retail copy comes up with. Microsoft SQL Server 2000 Standard (5-Client) Full Version Retail Box RETAIL Microsoft Part #: 228-00683 Save 18% off RETAIL $1,225.00 Retail $1,489.00 Jose -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jacob Stabl Sent: Wednesday, June 15, 2005 11:28 AM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] Passwords from SQL Educational price for MSSQL 2000 or whatever newest version is over $2000 -- Jake -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Pochedley Sent: Wednesday, June 15, 2005 2:06 PM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] Passwords from SQL Free to acquire, yes... However, if you spend enough time in implementing, creating, and supporting some functionality that you would otherwise gain in the paid solution (password syncing?), have you really "saved" any money? It's not a knock against "free" software... I use MySQL here and have used it for other personal applications as well... Sometimes "free" isn't always the best solution... Of course there's always the oft repeated quotes "Acquisition costs are only a fraction of TCO...." Joe Pochedley A computer terminal is not some clunky old television with a typewriter in front of it. It is an interface where the mind and body can connect with the universe and move bits of it about. -Douglas Adams -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of joe Sent: Wednesday, June 15, 2005 1:44 PM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] Passwords from SQL When you have next to nothing for a budget, next to nothing is a lot when you can get it for free. :o) Of course free is a question begging term but for any uses I have used MySQL for it has performed admirably. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Medeiros, Jose Sent: Wednesday, June 15, 2005 1:28 PM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] Passwords from SQL I am not sure why, Microsoft sells their products to education institutions for next to nothing. Jose -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Freddie Coleman III Sent: Wednesday, June 15, 2005 10:22 AM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] Passwords from SQL He's probably using MY SQL instead of MS SQL for monetary reasons. Money is always an issue in education fred > Hi Jacob, > > I have a better ID. If you use Microsoft SQL instead of MY SQL then > you'll have the option of using Integrated Authentication and use the > usernames and passwords that your user's log into AD with. > > Jose > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Jacob Stabl > Sent: Wednesday, June 15, 2005 8:56 AM > To: ActiveDir@mail.activedir.org > Subject: [ActiveDir] Passwords from SQL > > > > I am running a MySQL server that holds data for a grading program here > in the district. Well teachers have the ability to change passwords > through that software and I was curious if AD could import passwords > for people on a scheduled increment from that SQL database. Can > active directory connect to a SQL database to pull other information > or possibly import users directly from that database?? > > -- > Jacob Stabl > Network Engineer > Plain Local School District > <http://www.plainlocal.org> http://www.plainlocal.org > Office: 330.492.3500 > Cell : 330.704.1278 > IP Phone: 4466 List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
