How the SQL Server connect to ldap Server?

Asked By Phia_01 10 points N/A Posted on - 10/28/2012

Hello experts,

I have hard time on SQL server connect to ldap server. Can anyone help me about this? I need step by step procedure.

Thank You.

• Status: Open
• Question Views: 986
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: LDAP

Answered By Thornton Patricia 0 points N/A #161008

How the SQL Server connect to ldap Server?

Hi,

1.    Add linked server by executing existed store procedure sp_addlinked server then write query with ADSITest, active directory testadso object and ads datasource then go with stored procedure add linked for login and set attribute to  false.

2.    Write query select *  from your table with adsi test and account name and name with LDAP server ,username and password where your object category  selected.

3.    Before doing this set show advance options of configuration sp to 1 and adhoc distributed queries.

Hope these shall helps you

Thanks

About Thornton Patricia

Questions
3

Answers
101

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 11/04/2012
• Question Category: LDAP