Question about AD 2000

From: plsntn_rules (plsntnrules_at_discussions.microsoft.com)
Date: 01/13/05


Date: Thu, 13 Jan 2005 12:11:05 -0800

sI couldn't find a group dedicated specifically to AD question on Win 2000
server so i am going to post this question here...sorry

here's the scenario..

We currently have a web application that uses forms based authentication
which is stored in a SQL server database....So user logs in, the username is
vaidated against this sql database and then depending on their job function
another set of rules and permissions stored in a different table are run for
that particular user...

The business that use this application want to move the wuthentication peice
of this app from SQL to AD but leave the permissions table in this SQL
database...

So ideally, a user logs in, they are authenticated against AD and then the
request is passed back to this SQL server where the validated username is
matched against the same username in the table and then the appropriate
permissions set are granted.

Is there anything out there that can do this?
The business do not want to move the permission set to AD coz it is huge and
complicated and took them like 6 months to get right.

I know its a shot in the dark but is there anything out there that can
achieve this?

many thanks for any help....



Relevant Pages

  • Re: Removing users from WSS 2.0
    ... Let me second Mike's recommendation to never delete things in SQL. ... I believe his tool WSSUserUtil will completely remove users from sites and server. ... level administration, in view site collection user information after removing ... enter the username again and a random number is added to the username, ...
    (microsoft.public.sharepoint.windowsservices)
  • Windows authentication on SQL
    ... Use sql authentication, not windows authentication. ... >We are about the replace our SQL 7 server running on NT ... >running the SQL with the same username & password as the ...
    (microsoft.public.sqlserver.security)
  • Windows authentication on SQL
    ... We are about the replace our SQL 7 server running on NT 4.0 Enterprise to ... Windows 2k with SQL 2k - we will buy and install a new server and then move ... running the SQL with the same username & password as the user have on the ...
    (microsoft.public.sqlserver.security)
  • Crystal Enterprise manager
    ... When we look at the Server properties it says it is a Windows Server ... not have SQL except the SQL that is part of sharepoint ... The Install Says SQL Servr is configured for Windows Only ... Input an NT Username to create a Database. ...
    (microsoft.public.vb.crystal)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)