Setup Service to update Exchange Server

• frgood

  SSC Enthusiast

  Points: 112

  More actions

  October 9, 2002 at 10:08 am

  #105282

  Is there a method, connection or service that would allow me to setup a connection to our Exchange server address book?

  What I am looking at is having our Sql Server based HR application create or remove (new hire or terminate) employees in our global address book periodically. I cannot find any information on accessing the DB directly.

  Is this possible?

• Steven.

  SSCrazy Eights

  Points: 9806

  More actions

  October 10, 2002 at 6:25 am

  #438247

  I've done it with sql 2000/exchange 5.5 by using a linked server. Exchange 5.5 is a ldap datastore.

  For example

  EXEC sp_addlinkedserver

  @server = 'adsi',

  @srvproduct = 'Active Directory Services 2.5',

  @provider = 'ADSDSOObject',

  @datasrc = 'adsdatasource'

  select * from openquery

  (adsi, 'select sn, givenname from

  ''LDAP://<Exchange server>'' where objectClass=''Person'' and sn=''<name>''') adsiiris

  order by givenname

  Just remember to add the 'cn=' infront on the ldap username when you configure the linked server security!

  Steven