This project contains custom CLR functions for Microsoft SQL server, related to Active Directory. These functions allow the SQL server to query directly the Active Directory for users, computers, groups etc. The results are retrieved much faster than using the AD provider via Linked Servers.
List of CLR functions:
GetAttributes
GetComputers
GetDomainControllers
GetGroups
GetMembership
GetQueryAttributes
GetServers
GetUsers
SplitString
They use classes and methods located in PkgLdapUtils (the core AD library). The method LdapQueryMany uses tasks to increase the performance.
Notes:
- You need to have a healty AD domain;
- The computer on which resides the SQL server must be joined to your AD;
- You have to access the SQL server / instance by using name (not IP address!);
- All calls to domain controllers are impersonated (i.e. they run as the authenticated user);
- In general the SQL assemblies must be signed. If you're testing with unsigned assembly, your database must be marked as trustworthy:
ALTER DATABASE [DB_NAME_HERE]
SET TRUSTWORTHY ON
WITH ROLLBACK IMMEDIATE
Please note that this is an old project of mine and the source code may not conform current trends in naming conventions. Also some parts of the code may need to be refactored.