Use LDAP to authenticate users of a SQL Server database?

Question

Is it possible to use LDAP (not Active Directory) to authenticate users on a MS SQL Server database. We have business users who have SQL user accounts on the database, and want to switch that to an LDAP server (specifically, JumpCloud).

Rabbid76 · Accepted Answer · 2019-04-23 20:26:22Z

2

Yes it is possible if you consider this:

Each user has a local machine user account on both the server and the client
The local machine user account names on the server and the client match exactly - case, spaces, characters (handle the accounts with jumpcloud agent).
The passwords for the local machine account on the server and client match exactly - case, spaces, characters (set the passwords from jumpcloud)
Create permissions of local windows users on each sql database you will need to access (On SQL Management studio, expand the database, security, users, right click and add user of type windows user, browse on user name ..., type the username, check name and confirm it)

To have a better idea you can check https://jumpcloud.com/blog/managing-shared-ntfs-folders-local-accounts/

edited Apr 23, 2019 at 20:26

Rabbid76

212k30 gold badges163 silver badges205 bronze badges

answered Apr 23, 2019 at 19:55

Luis Vera

363 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Use LDAP to authenticate users of a SQL Server database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related