Is it possible to store database row information in Active Directory?

Question

Let's say you have many applications in your environment, all of which store their SQL Server connection strings in a web configuration. Is it possible for an application to retrieve these connection strings from Active Directory?

We are moving several database servers and would like them to read them from the center. Active Directory was proposed as one of the features, but we did not know if this was possible.

This theoretically will allow us to gradually change our applications to use AD to read connection strings, and then, when we move our database servers, we make one change in AD to update all applications.

Is it possible? Maybe you have a better offer. Thanks!

Answer 1

From a technical point of view, you cannot store information in LDAP , since it is a protocol, not a storage mechanism. However, there is no reason (I know) that you cannot store information in Active Directory or another directory service mode and receive it using a request from an application. You just need to come up with some kind of organizational chart, and I would suggest some general code in the library or something that allows you to access this information.

I'm not saying that storing it in Active Directory is the best option, but I believe that you can do it without problems.

Answer 2

, . , . Active Directory , , .

, , "" . Active Directory, .

, , .

Answer 3

"LDAP "

? Dit - ​​ , , . , Active Directory, " ".

Answer 4

, , , LDAP, IMO.

, , ​​ , , , .

, Spring Spring.NET, DI, .

UPDATE: , , , .

LDAP , , , .

Answer 5

. TXT DSN. . , . (, ). LDAP ( ldap), , . - - LDAP ( ), . , LDAP, . /, , . LDAP , .

there may be a better custom object or even an extension attribute for an existing object.

Extend AD schema