Connect Exchange 2000 Server to SQL 2000

I need to populate a Public Contacts Folder on an Exchange Server with data in a SQL 2000 Table. What would be the best way to do this?
ThanksPublic Contact Folder? or Populate a GAL with contacts?

I had to do it for my company but put it in the GAL and also make groups for regions of members etc. Big pain in the butt.

Without getting into too much detail, basically have to write a script to pull data into LDIF strings, then run a DTS that puts the strings into a csv or Text file in LDIF. Then Import that into Active directory using LDIFDE. Again this takes a long time ;p, your best bet might be to find someway to create an LDAP directory to use but unfortanatley that wasnt an option for me because I had to create query based distribution lists for my company members regions etc.

Configuring SQL 2005 Database Mail

I am trying to configure Database mail to work with our Exchange server but the only setting that I see is for a SMTP server. I find it hard to believe that this won't work with Exchange. Has anyone got this to work with an Exchange server?

Thanks!
JohnYes it does work with an Exchange Server as long as your exchange server is config'd to support SMTP.

I'm no exchange expert so I can't help you do this but we test Database Mail with Exchange as one of the mail platforms.

-Euan

Configuring mail for SQL Server Agent - Problem with Exchange and Outlook on same machine?

I would like to configure e-mail alerts on my SQL Server 2000 box.
However, we also run Exchange on the same machine. I've been told there
could be conflicts/issues having Outlook on the same machine as
Exchange; and apparently, one needs Outlook to configure a mail profile
for SQL Server Agent.

Is there, in fact, anything to worry about? If so, are there any
work-arounds beside moving Exchange to another server? (we've only got
one server, so this is not an option for us at this time).
Thanks.

- Dana<dananrg@.yahoo.com> wrote in message
news:1106142898.187937.44340@.z14g2000cwz.googlegro ups.com...
> I would like to configure e-mail alerts on my SQL Server 2000 box.
> However, we also run Exchange on the same machine. I've been told there
> could be conflicts/issues having Outlook on the same machine as
> Exchange; and apparently, one needs Outlook to configure a mail profile
> for SQL Server Agent.
> Is there, in fact, anything to worry about? If so, are there any
> work-arounds beside moving Exchange to another server? (we've only got
> one server, so this is not an option for us at this time).
> Thanks.
> - Dana

SQL Mail can sometimes be tricky to set up - you can check the MS Knowledge
Base for detailed articles on setup and troubleshooting. This is one
alternative approach:

http://www.karaszi.com/sqlserver/info_no_mapi.asp

I don't know if there are any problems with Exchange and Outlook on the same
box (you might want to ask in an Exchange group), but moving Exchange (or
MSSQL) to a separate server might be a good idea anyway, to avoid possible
resource conflicts. Although if you've been running both together for a
while, presumably that's not an issue for you right now.

Simon