Is there an SP that can authenticate AD user name and password

Posted on 2012-08-22
Last Modified: 2012-10-12
Is there a stored procedure in sql server that will allow me to pass a user name and password to check it against active directory users and return a value indicating if the user name exists and if the user name / password combination is valid.
Question by:BradleyCleveland
    LVL 5

    Accepted Solution

    No, you don't have option to it from SQL server.
    LVL 13

    Expert Comment

    Nothing out of the box but you can write CLR stored procedure in order to do that.
    LVL 1

    Author Closing Comment

    Not the answer I wanted, but evidently its the right one.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video discusses moving either the default database or any database to a new volume.

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now