NT authentication

Posted on 2005-05-13
Last Modified: 2013-12-04

We have a web app with ASP and SQL.  

When users want to use the site, they go to our company's website, type in their company name then submit.  It will redirect them to t ASP site(different ip), if company name exists in db, NT authentication window will pop up(I created the username and password in active directory), otherwise, it will redirect them back to company's website.  One NT authentication login is for one client.  When they enter the correct info, asp page will be prompted for the username and password(each client could have more than one users, but only one NT authentication)

If Client A enter different company name other than theirs(assume Client A knows all the clients'  company names), the NT authentication will pop up, because this company B exists in db, Client A can enter their NT authentication info to loginto client B's site, although client A does not have user level info to log into next step.

My question is, if there a way to tie active directory into sql........or.....

Question by:mcrmg
    LVL 24

    Accepted Solution

    Yes. But, it leads to major problems. Suppose, AD gets changed. Now the SQL is skewered royal. Major problem we get with out (now) legacy systems, is accomodating that kind of operation.

    Author Comment

    Is there a work around?  thx

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Suggested Solutions

    As I write this article, I am finishing cleanup from the Qakbot virus variant found in the wild on April 18, 2011.  It was a messy beast that had varying levels of infection, speculated as being dependent on how long it resided on the infected syste…
    This is a guide to the following problem (not exclusive but here) on Windows: Users need our support and we supporters often use global administrative accounts to do this. Using these accounts safely is a real challenge. Any admin who takes se…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now