MAPI profile without outlook
-
Hi all,
My current company does not want to install Outlook on production DB Servers, which I understand. However I now am unable to Use the sendmail task that I have grown to depend on, as there isn't a MAPI profile set up on the DB server.
Does anyone know how I might set this up without a mail client like outlook? I want to use the SendMail task, not an ActiveX script to send mail. I've read about newprof.exe (which no longer comes with outlook), but I have yet to find anything that anyone has had luck with.
Thanks for any help in advance,
J. Miles
-
Take the plunge and get rid of the MAPI dependency.
If you must use a task in DTS, instead of ActiveX Script, check out the DTS SMTP Task at http://www.sqldev.net
--------------------
Colt 45 - the original point and click interface
-
THANK YOU!!!
That was exactly what I needed.
Cheers,
J. Miles
-
You can also create an instance of SQL Server on your desktop, run distributed transactions to the production server to gather job failure information, then shoot out emails from your desktop.
-
It would really be nice if someone were to write a tiny and free MAPI client that would replace Outlook on SQL Servers. And when you do, make it open source.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
-
Why bother with the additional overhead of MAPI?
There is a perfectly useable free extended stored procedure that utilises SMTP available at http://www.sqldev.net
This was complimented recently with the addition of the DTS SMTP task.
--------------------
Colt 45 - the original point and click interface
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply