Re: ADSI


We are using username as firtsname.lastname password as plaintext. could
you please provide me more information on using the SQL and AD membership
providers for the integration with web application, how to implement it.

aslo we want to use this AD for MOSS 2007, my question is do I need to have
exchanger server for this to implementation, we are using this for government
site.


Regards,
Chris





"Joe Kaplan" wrote:

Can you provide more details on how the passwords are stored in the SQL
database? If they are in plaintext or encrypted in a reversible format,
then you should be able to recover them and use them provision identities in
AD or ADAM such that the users will have the same username and password they
used in SQL.

However, if they are in some sort of 1 way hash format, then it might be
very difficult to recover the plain text. That would make provisioning in
AD very difficult.

Username format might be a bit of a problem as well, depending the formats
you allow in SQL. You would want those to be compatible with AD. ADAM
gives you a little more flexibility here.

I definitely recommend that you try to use the SQL and AD membership
providers for the integration with your web application. They provide a
nice abstraction layer over the user store that makes it easier for your
application to not have to care where the users are stored. If you aren't
using the membership providers now, I recommend that as your first step.

Joe K.

--
Joe Kaplan-MS MVP Directory Services Programming
Co-author of "The .NET Developer's Guide to Directory Services Programming"
http://www.directoryprogramming.net
--
"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FBDD0F3B-CA1F-4658-893F-6B760047043E@xxxxxxxxxxxxxxxx
Joe ,

Thanks for quick respone.

We developed a site with public and privatre applications, for private
applications user need to login those users paswwords we dont want to
distrub, you are rite we want to use same passwords.

Any kind of possible other solutions also welcome( there is no time
constraint for development).

Regards,
Chris

"Joe Kaplan" wrote:

You haven't given us enough information about what you are doing to
provide
you with a useful answer. In terms of size, 75K users is not really
significant for AD from a size perspective. I wouldn't worry about that.

Migration of users may be tricky, depending a great deal on how you have
stored the users' passwords in SQL and whether your intent is for your
users
to have the same password they had before.

Joe K.

--
Joe Kaplan-MS MVP Directory Services Programming
Co-author of "The .NET Developer's Guide to Directory Services
Programming"
http://www.directoryprogramming.net
--
"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0620E3BC-F4D3-4A6C-A4B6-ADC27F591D37@xxxxxxxxxxxxxxxx
Hi All,

I have question about Active Directory. We have developed a site it has
75K
users on SQL server 2005 associated with roles, now we are thinking to
change
it to Active directory is it good idea or bad idea? if it is good how
to
migrate it.

Thanks in advance.

Chris






.

Relevant Pages

  • Re: ADSI
    ... providers for the integration with web application, ... used in SQL. ... Co-author of "The .NET Developer's Guide to Directory Services Programming" ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Accessing AD/ADAM from SQL
    ... You could still host all that code in SQL ... or place it in an external batch process or script. ... Co-author of "The .NET Developer's Guide to Directory Services Programming" ... pull information for building sql scripts. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Using AD and a Table for Membership and Roles
    ... at using AzMan for the granular permissions, not SQL. ... AzMan is a very powerful model for doing application-level ... Co-author of "The .NET Developer's Guide to Directory Services Programming" ... Each role will contain granular permissions - we want to store these ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: ado vs oledb
    ... Most mainstream SQL databases have "native" .NET providers using managed ... attempting to use a generic OLEDB provider--if you care about performance. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADSI
    ... Can you provide more details on how the passwords are stored in the SQL ... However, if they are in some sort of 1 way hash format, then it might be ... Co-author of "The .NET Developer's Guide to Directory Services Programming" ...
    (microsoft.public.dotnet.framework.aspnet.security)