From: "Medeiros, Jose" <[EMAIL PROTECTED]>
Reply-To: ActiveDir@mail.activedir.org
To: <ActiveDir@mail.activedir.org>
Subject: RE: [ActiveDir] Passwords from SQL
Date: Thu, 16 Jun 2005 09:44:21 -0700
MIME-Version: 1.0
Received: from mail.activedir.org ([12.168.66.190]) by mc4-f31.hotmail.com
with Microsoft SMTPSVC(6.0.3790.211); Thu, 16 Jun 2005 09:48:39 -0700
Received: from mail2.probusiness.com [12.40.212.80] by mail.activedir.org
with ESMTP (SMTPD32-8.15) id AC714DDA0136; Thu, 16 Jun 2005 12:44:33 -0400
Received: from Unknown [10.62.4.58] by mail2.probusiness.com - SurfControl
E-mail Filter (5.0); Thu, 16 Jun 2005 09:44:22 -0700
Received: from Unknown [10.62.4.65] by plsscan102.CORP.prbz.net -
SurfControl E-mail Filter (5.0); Thu, 16 Jun 2005 09:44:21 -0700
Received: from plsxch130.CORP.prbz.net ([10.62.4.72]) by
plsxch123.CORP.prbz.net with Microsoft SMTPSVC(5.0.2195.6713); Thu, 16 Jun
2005 09:44:21 -0700
X-Message-Info: JGTYoYF78jGMU70MuHhLYCdbZTXWaM3bAQ9XI3cYZSI=
X-SEF-Processed: 5_0_0_713__2005_06_16_09_44_23
X-SEF-2419BEE-9C3B-4234-9EB4-4472B2BD4169: 1
X-SEF-Processed: 5_0_0_713__2005_06_16_09_44_23
X-SEF-2A72E947-FFCD-4578-8AF8-C5998320E05E: 1
X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0
content-class: urn:content-classes:message
X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ActiveDir] Passwords
from SQL
Thread-Index:
AcVxzytVWHVVMKIbSHKaSJqlyXV/TAAACZyQAACWXwAAAJLjAAAA+uOwAAFRvuAAAKqV8AADigWAAAU08PAAAGSTQAACgCpwACEFWaA=
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 16 Jun 2005 16:44:21.0671 (UTC)
FILETIME=[A5764370:01C57292]
Precedence: bulk
Hi Rick,
Point well taken. I also do agree MYSQL is a fine database and a great
value.
Peace,
Jose Medeiros :-)
www.ntea.net
www.tvnug.org
www.sfntug.org
----------------------------------------------------
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Rick Kingslan
Sent: Wednesday, June 15, 2005 6:08 PM
To: ActiveDir@mail.activedir.org
Subject: RE: [ActiveDir] Passwords from SQL
The reason that it's off the point is because:
1) MySQL is the database in which the application is deployed.
2) Moving it the MSSQL might exceed the realistic 'cost' of the database
3) It might be just as easy to use OpenLDAP (I'm assuming MySQL on Linux)
and communicate with AD that way
Make no mistake - I'm no bigot when it comes to using MS software. Quite
the contrary. But, there are times when the simple economics of a solution
scream out that Microsoft is not the right solution.
Most schools that I work with are this way. Most of them would have to
save
a huge chunk of non-salary related expenditures to afford a Standard
version
of SQL. Hence, Access is a really popular option, even though getting it
to
work in some of the multi-user scenarios sucks - plainly and simply.
In one school that I work with, the majority of the desktop OSs that they
run are ones that I've donated. One of the servers OSs is as well.
I'm not saying the you're wrong. Far from it, in fact. But, sometimes the
solution can't meet the available economic resources.
Rick
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Medeiros, Jose
Sent: Wednesday, June 15, 2005 7: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/
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/
