SQL Tables as Exchange Address Books

Ken VdB · Joined: 06 Aug 2007 Posts: 2

Hi everyone,

Please excuse the cross posting but I have been searching long and hard for
an answer to this and haven't been able to find one. I can't be the only
person who needs to do this.

I have Exchange 2000 and SQL 2000 running on the same box. I have a number
of tables in SQL that contain email addresses. I need to somehow make these
email addresses available to Exchange (or Outlook).

Is there any way to do this? Can a newer version of Exchange or SQL do it?
Please let me know what your thoughts are.

Thanks,

Ken VdB

Archived from group: microsoft>public>exchange2000>interop

wei xiao · Joined: 06 Aug 2007 Posts: 1

What do you mean to make them available for exchange? Do you want them to
appear in the address book?

--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix

This posting is provided "AS IS" with no warranties, and confers no rights.

"Ken VdB" wrote in message @TK2MSFTNGP14.phx.gbl...
> Hi everyone,
>
>
>
> Please excuse the cross posting but I have been searching long and hard
> for an answer to this and haven't been able to find one. I can't be the
> only person who needs to do this.
>
>
>
> I have Exchange 2000 and SQL 2000 running on the same box. I have a
> number of tables in SQL that contain email addresses. I need to somehow
> make these email addresses available to Exchange (or Outlook).
>
>
>
> Is there any way to do this? Can a newer version of Exchange or SQL do
> it? Please let me know what your thoughts are.
>
>
>
> Thanks,
>
>
>
> Ken VdB
>
>

Ken VdB · Joined: 06 Aug 2007 Posts: 2

Yes, that is exactly what I would like. I see there being two approaches to
this.

1. Exchange connects to SQL and shows the table/view as part of the Global
Address Book
2. Outlook has another address book provider setup that connects directly to
SQL.

Option two is less convenient as it requires setup/configuration on each
client machine.

Ken.

"wei xiao" wrote in message @TK2MSFTNGP15.phx.gbl...
> What do you mean to make them available for exchange? Do you want them to
> appear in the address book?
>
>
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Ken VdB" wrote in
> message @TK2MSFTNGP14.phx.gbl...
>> Hi everyone,
>>
>>
>>
>> Please excuse the cross posting but I have been searching long and hard
>> for an answer to this and haven't been able to find one. I can't be the
>> only person who needs to do this.
>>
>>
>>
>> I have Exchange 2000 and SQL 2000 running on the same box. I have a
>> number of tables in SQL that contain email addresses. I need to somehow
>> make these email addresses available to Exchange (or Outlook).
>>
>>
>>
>> Is there any way to do this? Can a newer version of Exchange or SQL do
>> it? Please let me know what your thoughts are.
>>
>>
>>
>> Thanks,
>>
>>
>>
>> Ken VdB
>>
>>
>
>

John Abbott · Joined: 06 Aug 2007 Posts: 3

I have implemented similar systems that go through SQL and pull out the
email addresses, then add them to a OU in active directory as contacts with
the appropriate names and email addresses. I have also gone the other way
where I dredge active directory and populate SQL tables.

I use ADSI and VBScript. I have also used this to create address book
synchronization between co-existing email systems (cc:Mail, Exchange 5.5 in
a separate domain and groupwise). I set the scripts to run each night to
synchronize the systems.

Once you are familiar with ADSI, then it is relatively easy to accomplish
this.
--
JOHN ABBOTT

"Ken VdB" wrote in message @TK2MSFTNGP14.phx.gbl...
> Hi everyone,
>
>
>
> Please excuse the cross posting but I have been searching long and hard
> for an answer to this and haven't been able to find one. I can't be the
> only person who needs to do this.
>
>
>
> I have Exchange 2000 and SQL 2000 running on the same box. I have a
> number of tables in SQL that contain email addresses. I need to somehow
> make these email addresses available to Exchange (or Outlook).
>
>
>
> Is there any way to do this? Can a newer version of Exchange or SQL do
> it? Please let me know what your thoughts are.
>
>
>
> Thanks,
>
>
>
> Ken VdB
>
>

Global address list in multiple ORGs? We currently have a 4.0 domain with Exhcange 5.5 running on it. We are going to do a new install of a 2K ADS domain and new install of Exchange 2000. This will be run in parallel with the old domain but again in it's own fresh install and not upgraded.

Mounting an Exchange 2000 store on an Exchange 2003 server Hi all, I already suspect the answer might be *no* because I'm looking for an easy way to migrate from E2K to E2K3, and when it comes to Exchange, nothing is ever easy!! Can I mount a store taken from the E2K setup on the E2K3? Can I use RSG instead and m

Mounting an Exchange 2000 store on an Exchange 2003 server Hi all, I already suspect the answer might be *no* because I'm looking for an easy way to migrate from E2K to E2K3, and when it comes to Exchange, nothing is ever easy!! Can I mount a store taken from the E2K setup on the E2K3? Can I use RSG instead and m

Cannot send emails through Exchange server to other Exchange I have an issue with several sites running MS Exchange Servers that cannot send to other Exchange server sites. The issue seems to have started toward the end of November and seems to be a problem sending from newer Exchange servers to older one. For ex

Exchange Interoperability We're having a problem were our Exchange server is placing XML code that should be in the body of an email as an attachment. This began happening when we replaced our Exchange 5.5 server with Exchange 2003. In understand that this may be a 'communicatio