I have a stored procedure that validates userid/password against an (encrpyted) SQL Server table.
I would like to be able to extend the stored procedure to determine whether the userid/password is valid to ActiveDirectory.
I have added an LDAP linked server and can read it with an OPENQUERY, but I don't know how to check the password or whether this is possible.
I assume the other alternative is a CLR assembly linked to SQL Server, but I am wondering about the T-SQL approach.
Can it be done?