replicating with Active directory

Is they any feature that allows replication between Active Directory an SQL
server. I know I can write an assembly to do it but I'm checking on easier
ways first.
--
Regards,
Gary BlakelyHi
You can not replicate Active Directory to SQL Server, but you can interogate
the active directory using the ADSI adapter see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/active_directory_service_interfaces_adsi.asp
and
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/joining_heterogeneous_data.asp
If you want to have more resilience with your AD then you can replicated to
another Active Directory servers see
http://msdn2.microsoft.com/en-us/library/ms677921.aspx
John
"GaryDean" wrote:
> Is they any feature that allows replication between Active Directory an SQL
> server. I know I can write an assembly to do it but I'm checking on easier
> ways first.
>
> --
> Regards,
> Gary Blakely
>
>|||Hi Gary,
Did you mean that you want to setup a replication between two different
domains?
If you have to set up replication across two non-trusted domains or
workgroups by using Windows authentication, you must configure pass-through
authentication. Configure a local Windows account on both the Publisher and
the Subscriber that has the same name and password. After you configure
this account, use the account to start the SQL Server Agent service on the
Publisher for push subscriptions and on the Subscriber for pull
subscriptions. Make sure that this account is configured according to the
"Setting up Windows Services Accounts" topic in SQL Server Books Online.
If the user tries to make a network connection to a remote computer that is
in a non-trusted domain, the logon proceeds as if the user is connecting to
an account on the remote computer. The remote computer authenticates the
logon credentials against its directory database. If the account is not
defined in the directory database, but the guest account on the remote
computer is enabled and the guest account has no password set, the user
logs on with guest permissions. If the guest account is not enabled, the
logon is not successful.
For more information, please refer to:
HOW TO: Replicate Between Computers Running SQL Server in Non-Trusted
Domains or Across the Internet
http://support.microsoft.com/kb/321822/en-us
Please feel free to let me know if you have any other questions or
concerns.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi,
Happy New Year!
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================