I can fetch data back from LDAPS (port 636/3269) by first creating a Linked Server using
However, what I really need to do is to authenticate a Username/Password pair against LDAPS, to determine if the credentials are Valid.
I thought I could use
sp_addlinkedsrvlogin with the provided Username/Password, and if it succeeds, then use
sp_droplinkedsrvlogin to remove the linkage, these routines do not test for authentication at all.
What is the best way to use a Linked Server connection to LDAPS to authenticate Username/Password credentials? Is it possible to use an Extended Stored Procedure or the CLR to do this? I need to abstract this away from a .DLL because the same authentication needs to be used in a legacy application and on a website.