<div>
Nothing out of the box but you can write CLR stored procedure in order to do that.
</div>


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

<div>
Not the answer I wanted, but evidently its the right one.
</div>


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

<div>
<div class="content wysiwyg-content">
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.
</div>
</div>


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.

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

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.