如何从SQLServer查询LDAPoverSSL-HowtoQueryLDAPoverSSLfromSQLServer

Has anybody successfully queried LDAPS (LDAP over SSL/TLS) from SQL Server? How did you do it?

有没有人从SQL Server成功查询LDAPS（LDAP over SSL / TLS）？你是怎么做到的？

A client has asked us to set up our program on a network that uses LDAPS. I’ve used LDAP queries successfully at many other locations, but it’s not clear whether this will work with LDAPS, or what the syntax is. I would expect it to work, but not sure how to set it up.

客户要求我们在使用LDAPS的网络上设置我们的程序。我已经在许多其他位置成功使用过LDAP查询，但目前尚不清楚这是否适用于LDAPS，或者语法是什么。我希望它可以工作，但不知道如何设置它。

As a test, we tried setting up LDAPS on our own network. We can connect using ldp.exe, but attempting to query it from SQL consistently fails with “Msg 7321, Level 16, State 2…”

作为测试，我们尝试在自己的网络上设置LDAPS。我们可以使用ldp.exe进行连接，但尝试从SQL查询它始终失败，并显示“Msg 7321，Level 16，State 2 ...”

1. can a SQL query connect to LDAPS?
2. SQL查询可以连接到LDAPS吗？
3. Should I specify the port?
4. 我应该指定端口吗？
5. Does the server certificate need to be imported into SQL Server, or elsewhere?
6. 是否需要将服务器证书导入SQL Server或其他地方？
7. Are there other extra setup steps needed beyond those normally needed for querying LDAP?
8. 除了查询LDAP通常需要的那些之外，是否还需要其他额外的设置步骤？

Here’s the query that normally works, which I’m trying to modify for LDAPS.

这是通常有效的查询，我正在尝试修改LDAPS。

SELECT COUNT(*) FROM OPENROWSET('ADSDSOObject', 'adsdatasource'; 
'domain user here'; 'domain password here', 
    'SELECT SAMAccountName FROM 
''LDAP://192.168.0.105 
WHERE SAMAccountName = ''test.test'' and objectClass = ''user'' 
        ')

1 个解决方案