SQL Server to Microsoft Exchange

30 Oct 2008 11:16 AM

musosdev

Hi

I'm not sure if this is the right group, but I'm looking for information on
how to get our Contacts database (which is in SQLServer) into a Public
Address book on Microsoft Exchange.

I trawled the net and found the following article on SQLServerCentral...
http://www.sqlservercentral.com/articles/Miscellaneous/2985/ - however, I
cannot find the website for xp_sql2exchange to download the scripts or find
out more.

First of all, does anybody have any information as to what happened to this
set of scripts, where I might be able to download it, etc.

Alternatively, can anyone point me in the direction of anything that does
the same or a smilar job?

Thanks,

Dan

8 Nov 2008 6:34 PM

John Bell

Show quote Hide quote

"musosdev" <musoswire@community.nospam> wrote in message
news:60FEE1F4-26CB-417F-8981-8AF6AC2D8CE1@microsoft.com...
> Hi
>
> I'm not sure if this is the right group, but I'm looking for information
> on
> how to get our Contacts database (which is in SQLServer) into a Public
> Address book on Microsoft Exchange.
>
> I trawled the net and found the following article on SQLServerCentral...
> http://www.sqlservercentral.com/articles/Miscellaneous/2985/ - however, I
> cannot find the website for xp_sql2exchange to download the scripts or
> find
> out more.
>
> First of all, does anybody have any information as to what happened to
> this
> set of scripts, where I might be able to download it, etc.
>
> Alternatively, can anyone point me in the direction of anything that does
> the same or a smilar job?
>
> Thanks,
>
>
> Dan

Hi

Hopefully you are using Active Directory for contacts and you will need an
ADSI connection. You can retrieve this information but not set/create it in
this way. http://support.microsoft.com/kb/299410 should get you started.

John

27 Nov 2008 8:46 AM

musosdev

Show quote Hide quote

"John Bell" wrote:

>
> "musosdev" <musoswire@community.nospam> wrote in message
> news:60FEE1F4-26CB-417F-8981-8AF6AC2D8CE1@microsoft.com...
> > Hi
> >
> > I'm not sure if this is the right group, but I'm looking for information
> > on
> > how to get our Contacts database (which is in SQLServer) into a Public
> > Address book on Microsoft Exchange.
> >
> > I trawled the net and found the following article on SQLServerCentral...
> > http://www.sqlservercentral.com/articles/Miscellaneous/2985/ - however, I
> > cannot find the website for xp_sql2exchange to download the scripts or
> > find
> > out more.
> >
> > First of all, does anybody have any information as to what happened to
> > this
> > set of scripts, where I might be able to download it, etc.
> >
> > Alternatively, can anyone point me in the direction of anything that does
> > the same or a smilar job?
> >
> > Thanks,
> >
> >
> > Dan
>
> Hi
>
> Hopefully you are using Active Directory for contacts and you will need an
> ADSI connection. You can retrieve this information but not set/create it in
> this way. http://support.microsoft.com/kb/299410 should get you started.
>
> John
>

John,

Thanks for the info. Currently we are using an SQL Server table to store our
contacts database. From your response, I get the feeling you believe this to
be a bad idea.

Can you explain why using AD for contacts is better than putting them
directly into Exchange or pulling them from SQL Server?!

27 Nov 2008 8:20 PM

John Bell

Show quote Hide quote

"musosdev" <musoswire@community.nospam> wrote in message
news:7A661B98-58D9-48F6-9E37-1F37A993851F@microsoft.com...
>
>
> "John Bell" wrote:
>
>>
>> "musosdev" <musoswire@community.nospam> wrote in message
>> news:60FEE1F4-26CB-417F-8981-8AF6AC2D8CE1@microsoft.com...
>> > Hi
>> >
>> > I'm not sure if this is the right group, but I'm looking for
>> > information
>> > on
>> > how to get our Contacts database (which is in SQLServer) into a Public
>> > Address book on Microsoft Exchange.
>> >
>> > I trawled the net and found the following article on
>> > SQLServerCentral...
>> > http://www.sqlservercentral.com/articles/Miscellaneous/2985/ - however,
>> > I
>> > cannot find the website for xp_sql2exchange to download the scripts or
>> > find
>> > out more.
>> >
>> > First of all, does anybody have any information as to what happened to
>> > this
>> > set of scripts, where I might be able to download it, etc.
>> >
>> > Alternatively, can anyone point me in the direction of anything that
>> > does
>> > the same or a smilar job?
>> >
>> > Thanks,
>> >
>> >
>> > Dan
>>
>> Hi
>>
>> Hopefully you are using Active Directory for contacts and you will need
>> an
>> ADSI connection. You can retrieve this information but not set/create it
>> in
>> this way. http://support.microsoft.com/kb/299410 should get you started.
>>
>> John
>>
>
> John,
>
> Thanks for the info. Currently we are using an SQL Server table to store
> our
> contacts database. From your response, I get the feeling you believe this
> to
> be a bad idea.
>
> Can you explain why using AD for contacts is better than putting them
> directly into Exchange or pulling them from SQL Server?!

Hi

You can only query AD from a SQL Server linked server and not update it! AD
may offer more availability than exchange, but you may want to look at the
example http://msdn.microsoft.com/en-us/library/bb508823.aspx which uses
exchange web services.

John

1 Dec 2008 11:29 AM

musosdev

John,

Thanks for the info. As far as I can work out, contacts in the AD / exchange
store have to be "mail-enabled" in order to appear in the GAL. If we
mail-enable a contact, they are given an @ourdomain.com email address.

Is there any way to prevent this? We don't want 2000+ email accounts
creating in Exchange for contacts that don't work here!

Alternatively, the only way I can think of doing this is to poll sQL for the
contacts, not sure if there are any examples of this anywhere?!

Cheers

Dan

Show quoteHide quote

"John Bell" wrote:

>
> "musosdev" <musoswire@community.nospam> wrote in message
> news:7A661B98-58D9-48F6-9E37-1F37A993851F@microsoft.com...
> >
> >
> > "John Bell" wrote:
> >
> >>
> >> "musosdev" <musoswire@community.nospam> wrote in message
> >> news:60FEE1F4-26CB-417F-8981-8AF6AC2D8CE1@microsoft.com...
> >> > Hi
> >> >
> >> > I'm not sure if this is the right group, but I'm looking for
> >> > information
> >> > on
> >> > how to get our Contacts database (which is in SQLServer) into a Public
> >> > Address book on Microsoft Exchange.
> >> >
> >> > I trawled the net and found the following article on
> >> > SQLServerCentral...
> >> > http://www.sqlservercentral.com/articles/Miscellaneous/2985/ - however,
> >> > I
> >> > cannot find the website for xp_sql2exchange to download the scripts or
> >> > find
> >> > out more.
> >> >
> >> > First of all, does anybody have any information as to what happened to
> >> > this
> >> > set of scripts, where I might be able to download it, etc.
> >> >
> >> > Alternatively, can anyone point me in the direction of anything that
> >> > does
> >> > the same or a smilar job?
> >> >
> >> > Thanks,
> >> >
> >> >
> >> > Dan
> >>
> >> Hi
> >>
> >> Hopefully you are using Active Directory for contacts and you will need
> >> an
> >> ADSI connection. You can retrieve this information but not set/create it
> >> in
> >> this way. http://support.microsoft.com/kb/299410 should get you started.
> >>
> >> John
> >>
> >
> > John,
> >
> > Thanks for the info. Currently we are using an SQL Server table to store
> > our
> > contacts database. From your response, I get the feeling you believe this
> > to
> > be a bad idea.
> >
> > Can you explain why using AD for contacts is better than putting them
> > directly into Exchange or pulling them from SQL Server?!
>
> Hi
>
> You can only query AD from a SQL Server linked server and not update it! AD
> may offer more availability than exchange, but you may want to look at the
> example http://msdn.microsoft.com/en-us/library/bb508823.aspx which uses
> exchange web services.
>
> John
>

1 Dec 2008 7:23 PM

John Bell

Show quote Hide quote

"musosdev" <musoswire@community.nospam> wrote in message
news:373B6858-B703-4AB0-9437-40D1EC4B6D33@microsoft.com...
> John,
>
> Thanks for the info. As far as I can work out, contacts in the AD /
> exchange
> store have to be "mail-enabled" in order to appear in the GAL. If we
> mail-enable a contact, they are given an @ourdomain.com email address.
>
> Is there any way to prevent this? We don't want 2000+ email accounts
> creating in Exchange for contacts that don't work here!
>
> Alternatively, the only way I can think of doing this is to poll sQL for
> the
> contacts, not sure if there are any examples of this anywhere?!
>
> Cheers
>
>
> Dan
>

Hi Dan

You may want to ask these questions in and exchange newsgroup. My guess is
that you don't need the local email address if this is a SMTP contact.

John