Active Directory <-> SQL Integration ?

We have our user store in Active Directory. I am designing the data model
for some new applications, and a number of tables require fields such as
ApprovedBy, CreatedBy, etc. I want to be able to link these values back to
the Active Directory user store. I know I can just shove the AD user name i
n
there, but I want more. I want to have referential integrity between the tw
o
systems. Is this currently possible?
I'm going to assume it isn't possible, and if not is there a SQL Server wish
list/feedback email I can use to suggest this for a future product release?
I think this would be an extremely useful feature. (or if you could use SQL
Server as your Active Directory data store, that should solve the problem
also I believe, but I don't know if that is possible...).Hi
Check out the ADSI OLEDB provider.
http://msdn.microsoft.com/library/d...r />
_94fn.asp
If you can use check constraint that calls a function to implement RI, but
this sort of thing will probably prove prohibitably slow.
John
"Optikal" wrote:

> We have our user store in Active Directory. I am designing the data model
> for some new applications, and a number of tables require fields such as
> ApprovedBy, CreatedBy, etc. I want to be able to link these values back t
o
> the Active Directory user store. I know I can just shove the AD user name
in
> there, but I want more. I want to have referential integrity between the
two
> systems. Is this currently possible?
> I'm going to assume it isn't possible, and if not is there a SQL Server wi
sh
> list/feedback email I can use to suggest this for a future product release
?
> I think this would be an extremely useful feature. (or if you could use S
QL
> Server as your Active Directory data store, that should solve the problem
> also I believe, but I don't know if that is possible...).