[Last Call] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2012-08-22
Medium Priority
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

Accepted Solution

VIVEKANANDHAN_PERIASAMY earned 2000 total points
ID: 38323536
No, you don't have option to it from SQL server.
LVL 13

Expert Comment

ID: 38324911
Nothing out of the box but you can write CLR stored procedure in order to do that.

Author Closing Comment

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

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

825 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