Timeline for Can SQL Server OpenQuery/OpenRowSet to an LDAP Linked Server be used for Authentication?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 18, 2021 at 16:34 | history | edited | Daniel Bragg | CC BY-SA 4.0 |
Attempt to simplify and clarify the request
|
| Feb 18, 2021 at 2:05 | answer | added | J.D. | timeline score: 1 | |
| Feb 17, 2021 at 23:27 | history | edited | Daniel Bragg | CC BY-SA 4.0 |
Added more detail into what I am currently looking for, and to explain that sp_addlinkedsrvlogin can't be used for this.
|
| Feb 17, 2021 at 22:18 | comment | added | Daniel Bragg |
I've read in places the possibility of using an Extended Stored Procedure that could access IADsOpenDSObject:: OpenDSObject. Does anyone have any code on how that would looks like (I have no Extended Stored Procedure or CLR experience), and know whether that would be able to address the new LDAPS (port 636/3269) requirements?
|
|
| Feb 17, 2021 at 22:09 | comment | added | Daniel Bragg |
I have found that sp_addlinkedsrvlogin does no authentication, it only sets up a login with the credentials you provide. I cannot use this for authentication.
|
|
| Feb 17, 2021 at 21:39 | comment | added | Daniel Bragg | Agreed, however, we decided to investigate this because we needed to perform the same functionality from within an old windows application (written in Delphi 5, and not accessible to new libraries) as well as a website. SQL queries are one of the most accessible intersecting points between the two environments. | |
| Feb 17, 2021 at 21:29 | comment | added | LowlyDBA - John M | The best practice would be to not do this in a database at all. | |
| Feb 17, 2021 at 21:21 | history | asked | Daniel Bragg | CC BY-SA 4.0 |